Datatype compatibility

BIGINT

-9,223,372,036, 854,775,808 to 9,223,372,036, 854,775,807.

decimal

10^-38 to 10³⁸, 38 significant digits.

BLOB

variable length, 2GB, binary data

image

2GB

CHAR

254 bytes

char

32K

CHAR FOR BIT DATA

254 bytes, binary data

binary

32K

CLOB

variable length, 2GB, character data

text

2GB

DATE

0001-01-01 to 9999-12-31

char or datetime

32K (char)

If the pdb_convert_datetime parameter is false, DATE values are sent as char datatype strings. If the pdb_convert_datetime parameter is true, DATE values are converted to datetime values.

DBCLOB

variable length, 2GB, double-byte character data

text

2GB

DECIMAL

-10³¹+1 to 10³¹-1, 31 digits of precision

decimal

10^-38 to 10³⁸, 38 significant digits.

DOUBLE

See FLOAT.

FLOAT

8 bytes, -1.79769³⁰⁸ to 1.79769³⁰⁸

float

The float precision and range corresponds to a C double datatype, approximately 16 significant digits.

Extremely small values are truncated to 16 digits to the right of the decimal. Extremely large values retain their precision.

GRAPHIC

127 characters, double-byte character data

unichar or char

32K

To use the unichar datatype, the use_rssd parameter must be true and the replication definition must specify a Unicode datatype.

INTEGER

-2,147,483,648 to 2,147,483,647

int

-2,147,483,648 to 2,147,483,647.

LONG VARCHAR

variable length, 32,700 bytes, character data

varchar

32K

LONG VARCHAR FOR BIT DATA

32,700 bytes, binary data

varbinary

32K

LONG VARGRAPHIC

16,350 characters, double-byte character data

univarchar or varchar

32K

To use the univarchar datatype, the use_rssd parameter must be true and the replication definition must specify a Unicode datatype.

NUMERIC (synonym for DECIMAL)

See DECIMAL.

REAL

-3.402³⁸ to 3.402³⁸

decimal

10^-38 to 10³⁸, 38 significant digits.

SMALLINT

-32,768 to 32,767

smallint

-32,768 to 32,767

TIME

00:00:00 to 24:00:00

char or datetime

32K (char)

TIMESTAMP

0001-01-01-00.00.00.000000 to 9999-12-31-24.00.00.000000

char or datetime

32K (char)

If the pdb_convert_datetime parameter is false, TIMESTAMP values are sent as char datatype strings. If the pdb_convert_datetime parameter is true, TIMESTAMP values are converted to datetime values.

VARCHAR

32,672 bytes

varchar

32K

VARCHAR FOR BIT DATA

32,672 bytes, binary data

varbinary

32K

VARGRAPHIC

16,336 characters, double-byte character data

univarchar or varchar

32K

To use the univarchar datatype, the use_rssd parameter must be true and the replication definition must specify a Unicode datatype.