This content has been marked as final.
Show 3 replies

1. Re: Displaying all digits EAN numbers
comment_1 Apr 9, 2010 12:50 AM (in response to pitagora)EAN "numbers" are text (the leading digit/s can be zero) and should be stored in a Text field.

2. Re: Displaying all digits EAN numbers
pitagora Apr 9, 2010 1:22 AM (in response to pitagora)actually the last digit is a check digit
 From the right to left, start with odd position, assign the odd/even position to each digit.
 Sum all digits in odd position and multiply the result by 3.
 Sum all digits in even position.
 Sum the results of step 3 and step 4.
 divide the result of step 4 by 10. The check digit is the number which adds the remainder to 10.
so we could consider EAN code as a number...
but changing field type to text it's ok

3. Re: Displaying all digits EAN numbers
comment_1 Apr 9, 2010 1:53 AM (in response to pitagora)Checksum can be (and often is) applied to text data. A number is something that you use for numerical operations. You do not use EAN numbers (or phone numbers, credit card numbers, IP numbers, ZIP codes, etc.) to add, subtract, multiply or divide.