|
|
Ispirer SQLWays Database Migration Software
char, nchar, varchar and nvarchar
char[(n)]
Fixed-length character data in single-byte character sets with length of n characters. n must be a value from 1 through 255. Storage size is n bytes.
nchar[(n)]
Fixed-length character data in multibyte character sets with length of n characters. n must be a value from 1 through 255. Storage size is n*@@ncharsize bytes.
varchar[(n)]
Variable-length character data in single-byte character sets with length of n characters. n must be a value from 1 through 255. Storage size is the actual length of the data entered, not n bytes.
nvarchar[(n)]
Variable-length character data in multibyte character sets with length of n characters. n must be a value from 1 through 255. Storage size, in bytes, is the actual number of characters entered * @@ncharsize.
Remarks
When n is not specified in a data definition, the default length is 1.
|
|