Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Product Manuals » ElevateDB Version 2 Manual for RAD Studio XE7 (Delphi Win32) » DBISAM Migration » Types |
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. |
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 | Description |
INTERVAL | ElevateDB now supports all day-time and year-month interval types. Please see the Interval Types topic for more information. |
This web page was last updated on Thursday, November 16, 2023 at 10:39 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |