Character data types

Character data types store strings of letters, numbers, and other symbols.

UltraLite supports the CHAR, VARCHAR, and LONG VARCHAR data types, which are stored in a single- or multi- byte character set, and are often chosen to correspond most closely to the primary language or languages stored in the database.

Storage

Fixed character types, such as VARCHAR, are embedded in the row whereas long character types, such as LONG VARCHAR, are stored separately.

Consider your page size when creating a table with many columns of large fixed types. A full row must fit on a page, and fixed character column types are stored with a row. For example, a database created with a page size of 1000 is not able to hold character values larger than 1000 because they cannot fit on the page.

Character data types

Storage

See also