What is the standard length of a Barcode?
A UPC barcode contains 12 digits.
However, most of the places/countries it's 13-digit EAN barcodes to identify products.
Bar Code Preferred DataType and Limit
So, CHAR(13) would probably be the most appropriate data type to store this data.
Related Article
https://learn.microsoft.com/en-us/sql/t-sql/data-types/data-types-transact-sql?view=sql-server-ver16
Additionally,
Please also read about SQL Server 'ODA'
O - ODBC Connection String
D - Data Tools
A - Azure Blob Storage
Best Regards
Amit Vaid
A UPC barcode contains 12 digits.
However, most of the places/countries it's 13-digit EAN barcodes to identify products.
Bar Code Preferred DataType and Limit
So, CHAR(13) would probably be the most appropriate data type to store this data.
Related Article
https://learn.microsoft.com/en-us/sql/t-sql/data-types/data-types-transact-sql?view=sql-server-ver16
Additionally,
Please also read about SQL Server 'ODA'
O - ODBC Connection String
D - Data Tools
A - Azure Blob Storage
Best Regards
Amit Vaid
No comments:
Post a Comment