Gladius supports the following string types:
|
Alias
|
Storage type
|
Maximum length
|
|
char
|
VARCHAR
|
unlimited or user-defined
|
|
varchar
|
|
text
|
TEXT
|
unlimited, stored in external file
|
The CHAR and VARCHAR types are declared with a length that indicates the maximum
number of characters you want to store. For example, CHAR(30) can hold up to 30
characters.
The length of a VARCHAR column is fixed to the length that you declare when you create the
table. The length can be any value from 0 to 65535, and they are stored using the exact
number of characters needed plus 5-10 characters for the string definition.
Note: trailing spaces are not removed when storing VARCHAR values
If you assign a value to a CHAR or VARCHAR column that exceeds the column's maximum
length, the value is truncated to fit and a warning is generated.
All strings are binary safe and you can store binary values such as results from an encryption
or compression function with arbitrary byte values in them.
If your supposed string length is bigger than 255 characters it can be more efficient the usage
of the TEXT type; TEXT values are stored in separate files and retrieved when querying the
specific interested field.