Icon Types

Removed Types
The following are the types that have been removed:

RemovedDescription
AUTOINCThis 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.
MONEYThis 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.
GRAPHICThis 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.
WORDThis 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:

ChangedDescription
CHARThe 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.
VARCHARThe 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.
LONGVARBINARYThis 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.
BITThis shorthand notation for the BOOLEAN type is no longer permitted.
LARGEINTThis type has been renamed to BIGINT.
FLOATThe 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:

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