Supported Data Types

Pervasive DataExchange Data Types

This appendix contains the following topics:

Data Types

Notes on Data Types

 

Data Types

The following table lists the Pervasive PSQL data types supported by Pervasive DataExchange.

Pervasive PSQL Data Type	Pervasive DataExchange Implementation	Can be Used as Primary Key for Replication
Bit	bool	no
Tinyint	byte	yes
Utinyint	byte	yes
Decimal	numeric	yes
Numeric1	numeric	no
Bigint1	numeric	no
Ubigint1	numeric	no
Currency1	numeric	no
Longvarbinary	blob	no
Binary	blob	no
Longvarchar	blob	no
Char2	string	yes
Varchar3	string	yes
Integer	long	yes
Uinteger	long	yes
Identity4	long	yes
Smallint	short	yes
Usmallint	short	yes
Smallidentity	short	yes
Float	double	yes
Real	double	yes
Double	double	yes
Date	timestamp	yes
Time	timestamp	yes
Timestamp	timestamp	yes

Note :
1Partially supported data type in Pervasive PSQL. Refer to the appendix on Pervasive PSQL supported data types in the SQL Engine Reference.
2Limited to 255 characters.
3Limited to 254 characters.
4Although Identity is supported in Pervasive DataExchange for replication primary keys, using it for any part of a unique index is strongly discouraged.

Notes on Data Types

This section outlines special information regarding the use of data types in Pervasive DataExchange.

DECIMAL

DECIMAL is implemented in Pervasive DataExchange as a NUMERIC and can be use as a primary key for replication.

NUMERIC, BIGINT, UBIGINT and CURRENCY

The other data types that are implemented as NUMERICS cannot be used as primary keys for replication. These include NUMERIC, BIGINT, UBIGINT, and CURRENCY.

CHAR

The CHAR data type is limited to 255 characters.

VARCHAR

The VARCHAR data type is limited to 254 characters.

IDENTITY

Although you may use IDENTITY data types for primary keys in DataExchange, we strongly recommend that you not use this data type as part of a unique index.