|
|
Ispirer SQLWays Database Migration Software
char, nchar, varchar and nvarchar
char[(n)]
Fixed-length non-Unicode character data with length of n characters. n must be a value from 1 through 8,000. Storage size is n bytes.
nchar[(n)]
Fixed-length Unicode character data with length of n characters. n must be a value from 1 through 4,000. Storage size is two times n bytes.
varchar[(n)]
Variable-length non-Unicode character data with length of n characters. n must be a value from 1 through 8,000. Storage size is the actual length of the data entered, not n bytes. The data entered can be 0 characters in length.
nvarchar[(n)]
Variable-length Unicode character data with length of n characters. n must be a value from 1 through 4,000. Storage size, in bytes, is two times the number of characters entered. The data entered can be 0 characters in length.
Remarks
When n is not specified in a data definition, the default length is 1.
|
|