|
|
Ispirer SQLWays Database Migration Software
CHAR, VARCHAR and LONG VARCHAR
CHAR, VARCHAR and LONG VARCHAR data types are used to store character data. A character data is a sequence of bytes, the length of the character value is the number of bytes in this sequence. If the length is zero, the value is called the empty string. This value should not be confused with the NULL value.
CHAR[(n)] [FOR BIT DATA]
CHARACTER[(n)] [FOR BIT DATA]A fixed-length character data. The range of n is 1 to 254 characters. When n is not specified the dafault value is 1.
When CHAR values are stored, they are right-padded with spaces to the specified length. When CHAR values are retrieved, trailing spaces are removed.
FOR BIT DATA option specifies that the contents of the column are to be treated as bit (binary) data. During data exchange with other systems, code page conversions are not performed.
VARCHAR(n) [FOR BIT DATA]
CHARACTER VARYING(n) [FOR BIT DATA]
CHAR VARYING(n) [FOR BIT DATA]A variable-length character string. The range of n is 1 to 32 672 characters.
Value is stored in database using only as many characters as it contains, plus a few bytes to record the length. When the value is stored trailing spaces are removed.
FOR BIT DATA option specifies that the contents of the column are to be treated as bit (binary) data. During data exchange with other systems, code page conversions are not performed.
LONG VARCHAR [FOR BIT DATA]
A variable-length character string. The maximum length is 32 700 characters.
FOR BIT DATA option specifies that the contents of the column are to be treated as bit (binary) data. During data exchange with other systems, code page conversions are not performed.
|
|