Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
The VARCHAR data type stores character data, up to 32767 bytes.
VARCHAR [ ( max-length ) ]
The maximum length of the string. This default value is 1.
UltraLite databases only support byte-length semantics. A non-English character can require up to 3 bytes of storage.
UltraLite Java edition databases only support character-length semantics. max-length can be a maximum of 32767 characters.
Multibyte characters can be stored as VARCHAR, but the declared length refers to bytes, not characters.
UltraLite compacts data as much as possible. When a VARCHAR value does not require the number of bytes specified by max-length, then only the number of bytes needed to store the value is used.
Although it is possible to create a table with a VARCHAR column where the max-length exceeds the page size, an error occurs if you insert a value with a length exceeding that page size.
When evaluating expressions, the maximum length for a temporary character value is 2048 bytes.