Take the 2-minute tour ×
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. It's 100% free, no registration required.

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
1  
That document you reference at GS1.org 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

1 Answer 1

up vote 0 down vote accepted

As the maximum number of characters in a single symbol is 48 and the Technical Spec for aggregators (http://www.gs1.org/sites/default/files/docs/gs1-source/TSD_v1_1_Technical_Implementation_Guide_for_Aggregators.pdf) indicates the file can come in as UTF-8. UTF-16, or UTF-32, the safest bet would be

nvarchar(48)
share|improve this answer

Your Answer

 
discard

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.