SQL - Structured Query Language

Character Data Types

Data Type is an attribute that defines type of data of an object in the SQL Server. Each Table Column, Program Variable, Expression and Parameter must be defines with unique data types to optimize database operation in the SQL Server.

SQL Server deployed with Exact Numerics, Approximate, Numerics, Data and Time, Character Strings, Unicode Character String, Binary Strings and Other System Data Types. SQL Server can deploy with Alias Data Types that are based on the system supplied data types. SQL Server can deploy with User Defined Data Types that can form and execute through .NET Programming Language.

Character Strings
Data Type	Range	Storage
char	1 to 8000 non-Unicode Characters	Min 1 Byte Max value of N Bytes
varchar	1 to 8000 non-Unicode Characters	Min 1 Byte Max actual length of data + 2 Bytes
text	1 to 2^31-1 non-Unicode Characters	Min 1 Byte Max value of N Bytes

Unicode Character Strings
Data Type	Range	Storage
nchar	1 to 4000 Unicode Characters	Min 1 Byte Max value of N * 2 Bytes
nvarchar	1 to 4000 Unicode Characters	Min 1 Byte Max two times of actual length of data + 2 Bytes
ntext	1 to 2^30 ? 1 Unicode Characters	Min 1 Byte Max value of N * 2 Bytes

Binary Strings
Data Type	Range	Storage
binary	1 to 8000 Binary Data	Min 1 Byte Max value of N Bytes
varbinary	1 to 8000 Binary Data	Min 1 Byte Max actual length of data + 2 Bytes
image	0 To 2^31-1 Binary Data	Min 1 Byte Max value of N Bytes

* * * * *

Your Comment To AUTHOR