Dialect 3 Clients and Databases

Go Up to Understanding SQL Dialects

In dialect 3, the InterBase server interprets transition features as InterBase 6 SQL 92-compliant:

• Double quoted strings are treated as delimited identifiers.
• Dialect 3 DATE data type fields contain only date information. Dialect 3 clients expect only date information from a field of data type DATE.
• The TIME data type is available, and stores only time information.
• Dialect 3 databases store DECIMAL and NUMERIC data types with precision greater than 9 as INT64 if, and only if, they are in columns that were created in dialect 3.
• Dialect 3 clients expect DECIMAL and NUMERIC data types with precision greater than 9 to be returned as INT64.

To learn how to migrate older data to INT64 storage, see Do you really need to migrate your NUMERIC and DECIMAL data types? and Migrating NUMERIC and DECIMAL Data Types.