Legacy Data Types
Some older (legacy) data types are not supported by the current release of Pervasive PSQL. The following table shows the new data type to use in place of the legacy data type.
Table 134
Data Types Used to Replace Legacy Data Types
Legacy Type
Type Code
Replaced by
Type Code
LOGICAL(1)
7
BIT
16
LOGICAL(2)
7
SMALLINT
14
LSTRING
10
VARCHAR
11
LVAR
13
LONGVARCHAR
21
NOTE
12
LONGVARCHAR
21
Existing databases that use these data types are supported and function correctly. New databases cannot create tables with the legacy data types. However, a table with legacy data types can be added to the DDFs for a new database with the IN DICTIONARY clause. See
CREATE TABLE
.