Types

Removed Types

The following are the types that have been removed:

Removed

Description

AUTOINC	This type is no longer supported. Use the INTEGER type instead to store integer values, and use the GENERATED clause in a column definition to dictate that a column should be generated as an IDENTITY column. Please see the CREATE TABLE topic for more information.
MONEY	This type is no longer supported. Use the FLOAT type instead to store double-precision floating-point values. Please see the Approximate Numeric Types topic for more information.
GRAPHIC	This type is no longer supported. Use the BLOB type instead to store graphics or any other large binary objects. Please see the Binary Types topic for more information.
WORD	This type is no longer supported. Use the INTEGER type instead to store word values. Please see the Exact Numeric Types topic for more information.

Type Changes

The following are the changes to the types:

Changed

Description

CHAR	The CHAR (or CHARACTER) type now uses a fixed-length representation according to the SQL standard. Any strings that are shorter than the defined length of the column are padded with blanks.
VARCHAR	The alternate CHARACTER VARYING syntax is now acceptable. Also, VARCHAR columns no longer right-trim any spaces from strings that are stored in them. The string values are stored as-is.
BYTES or BINARY VARBYTES or VARBINARY	These types have been renamed to BYTE and VARBYTE (or BYTE VARYING), respectively.
LONGVARBINARY	This type has been renamed to BINARY LARGE OBJECT. The shorthand BLOB type notation is still retained also.
MEMO LONGVARCHAR	These types have been renamed to CLOB and CHARACTER LARGE OBJECT, respectively.
BIT	This shorthand notation for the BOOLEAN type is no longer permitted.
LARGEINT	This type has been renamed to BIGINT.
FLOAT	The alternate DOUBLE PRECISION syntax is now acceptable.
DATE TIME TIMESTAMP	Date, time, and timestamp literals must now be preceded with the DATE, TIME, and TIMESTAMP keywords, respectively.

New Types

The following are the new types:

New	Description

INTERVAL

ElevateDB now supports all day-time and year-month interval types. Please see the Interval Types topic for more information.

More Support Options