Dialect 1 Clients and Databases

Go Up to Understanding SQL Dialects

In dialect 1, the InterBase 6 and later servers interpret transition features exactly as an InterBase 5 server does:

• Double quoted text is interpreted as a string literal. Delimited identifiers are not available.
• The DATE data type contains both time and date information and is interpreted as TIMESTAMP; the name has changed but the meaning has not. Dialect 1 clients expect the entire timestamp to be returned. In dialect 1, DATE and TIMESTAMP are identical.
• The TIME data type is not available.
• Dialect 1 databases store DECIMAL and NUMERIC data types with precision greater than 9 as DOUBLE PRECISION, not INT64.
• Dialect 1 clients expect information stored DECIMAL and NUMERIC data types to be returned as double precision; such clients cannot create database fields to hold 64-bit integers.

InterBase 6 and later servers recognize all the other InterBase features in dialect 1 clients and databases.