|
varchar(n)
The term varchar(n) describes a
datatype.
Like all
character datatypes
the datatype varchar(n) is also compatible to the
ANSI-standard.
It requires 0 to n
bytes
of
storage,
depending on the number of characters specified.
The range of values for the variable n is from 1 to 255
(ASE® version
12.0) and from 1 to 16384 (starting with ASE® version 12.5).
Usage of the datatype varchar(n)
The datatype varchar(n) is used to store
character sets,
with a variable length (variable-sized character string). varchar(n) should be used, if
the
"character set"
to be stored requires only one byte of storage per character, i.e.
singlebyte character sets,
like, for example, English. So-called
multibyte character sets,
like, for example, Japanese or Chinese
should be stored in columns defined with the datatype
nvarchar(n).
See also:
nchar,
nvarchar,
text,
unichar(n),
univarchar(n).
|
