Monday, December 18, 2017  
You are here:  Knowledge base * MSSQL Server * MS SQL Field Lengths Register  Login
MS SQL Server field lengths

Here tou can find which length is used for a MS SQL Field

 

Data type Default length (characters)
Char Length defined for the column
Varchar Length defined for the column
Nchar Twice the length defined for the column
Nvarchar Twice the length defined for the column
Text 0
Ntext 0
Bit 1
Binary Twice the length defined for the column + 1
Varbinary Twice the length defined for the column + 1
Image 0
Datetime 24
Smalldatetime 24
Float 30
Real 30
Int 12
Bigint 19
Smallint 7
Tinyint 5
Money 30
Smallmoney 30
Decimal 41*
Numeric 41*
Uniqueidentifier 37
Timestamp 17

See also:
Microsoft Knowledge Base

 


 
Home  |  Company  |  Products  |  Contact  |  Downloads  |  Knowledge base
Copyright (c) 2017 FRENT IT   |  Privacy Statement  |  Terms Of Use