Thanks to your help all my products have now a 14-digit ean code, which is great for consistency and for mapping them.
However when I search for an ean code on my site it is not ideal as it only shows the searched product if the ean code is a 100% match.
Let's say a product has the following ean code 123456789123. In my database that will be 00123456789123. If I do a search for 12345678912 or 012345678912, there will be no result. Do you have any good advice how can I overcome this problem?