Tuesday, December 6, 2022

SQL Server Data Types

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

No comments: