Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

In regards to GS1 barcode - what size DB field is used or is the entire GS1 typically not stored in database, but rather processed in the application layer and stored in the database as a collection of the component parts?

The length of the GS1 in its entirety is the subject of this question

share|improve this question
Are you planning on storing the ASCII characters or the image itself? If ASCII characters, then you could use a varchar(x) field, where 'x' is the maximum length you need, or possibly a varbinary(x) field. – Max Vernon Apr 19 '13 at 17:10
Planning on storing the ASCII characters unless someone with experience recommends parsing and storing. Trying to find x. – Thronk Apr 19 '13 at 17:36
That document you reference at says The maximum number of data characters in a single symbol is 48. on page 253 under GS1 - 128 Bar Code size characteristics: – Max Vernon Apr 19 '13 at 18:09
up vote 0 down vote accepted

As the maximum number of characters in a single symbol is 48 and the Technical Spec for aggregators ( indicates the file can come in as UTF-8. UTF-16, or UTF-32, the safest bet would be

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.