Clients and Databases

Go Up to Migration Issues

Clients and databases each have dialects. Servers do not themselves have a dialect, but they interpret data structures and client requests based on the dialect of each. Applications using an older version of the InterBase client work with InterBase 6 and later servers and their databases with some restrictions:

• Version 5 clients cannot access dialect 3 columns that are stored as INT64, TIME, or DATE. (DECIMAL and NUMERIC columns with precision greater than 9 are stored as INT64.)
• Version 5 clients cannot display new data types in metadata using the SHOW command, or any equivalent.
• Version 5 clients interpret the DATE data type as TIMESTAMP, since that was the definition of DATE prior to InterBase 6.
• Version 5 clients cannot access any object named with a delimited identifiers.