|
|
Ispirer SQLWays Database Migration Software
char, varchar and long varchar
Character data types are used to store character data.
char[(n)]
character[(n)]Fixed-length character data with length of n characters. n must be a value from 1 through 32767. For strings up to 254 bytes, the storage size is n +1 bytes. There are more additional bytes used for longer strings.
You can store multi-byte characters as the char data type.
varchar[(n)]
character varying[(n)]Variable-length character data with length of n characters. n must be a value from 1 through 32767. For strings up to 254 bytes, the storage size is n +1 bytes. There are more additional bytes used for longer strings.
You can store multi-byte characters as the varchar data type.
long varchar
Variable-length character data. The size is limited by the maximum size of the database file (currently 2 Gb). There are some subsidiary bytes used for storage in addition to the length of the string.
Remarks
When n is not specified in a data definition, the default length is 1. Data type lengths of less than one are not allowed. After the 255th byte characters are stored separately form the row containing the long string value.
|
|