Legacy Data Types

Pervasive logo

SQL Engine Reference

Legacy Data Types

Some older (legacy) data types are not supported by the current release of Pervasive.SQL. The following table shows the new data type to use in place of the legacy data type.

Table A-4 Data Types Used to Replace Legacy Data Types

Legacy Type

Type Code

Replaced by

Type Code

LOGICAL(1)

7

UTINYINT

14

LOGICAL(2)

7

USMALLINT

14

LSTRING

10

VARCHAR

11

LVAR

13

LONGVARCHAR

21

MONEY

6

DECIMAL

5

NOTE

12

LONGVARCHAR

21

*Table A-4 Data Types Used to Replace Legacy Data Types*
Legacy Type	Type Code	Replaced by	Type Code
LOGICAL(1)	7	UTINYINT	14
LOGICAL(2)	7	USMALLINT	14
LSTRING	10	VARCHAR	11
LVAR	13	LONGVARCHAR	21
MONEY	6	DECIMAL	5
NOTE	12	LONGVARCHAR	21

Prev
Notes on Data Types

Contents
Up
Check for Revisions

Next
Btrieve Key Data Types