Clients and Databases

From InterBase

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.

Advance To:

Retrieved from "https://docwiki.embarcadero.com/InterBase/2020/e/index.php?title=Clients_and_Databases&oldid=24693"