ASA SQL Reference
SQL Data Types
Character data types
Same as CHAR.
{ VARCHAR | CHARACTER VARYING } [ ( max-length ) ]
The default value of max-length is 1.
For strings up to 254 bytes in length, the storage requirements are the number of bytes in the string plus one additional byte. For longer strings, there is more overhead.
Strings of multi-byte characters can be held as the CHAR data type, but it is important to note that max-length is in bytes, not characters.
max-length The maximum length of the string, in bytes. The maximum size allowed is 32767.
SQL/92 Compatible with SQL/92.
Sybase Compatible with Adaptive Server Enterprise. The maximum max-length for Adaptive Server Enterprise is 255.
LONG VARCHAR data type [Character]