Skip to content

Important specialities

If at any point special knowledge regarding firebirdsql is required this [link](Firebird 2.5 Language Reference leads directly to the official documentation.

1. Datatypes and Dialects

In firebirdsql there are 3 dialects which support different kind of data types or in other words sometimes they don't.

These are the 3 main differences in terms of the dialects:

firebirdsql-dialects.png
This link leads to the official documentation of firebirdsql so for the latest information on current changes it should be looked up.

2. Schemas and Databases

Another important thing to know is that in firebirdsql the naming "SCHEMA" doesn't seem to exist instead it is known as "DATABASE". In other words there are no schemas but only databases in firebird.
This leads to the main thing to know. It is not possible/directly supported to access data from another database(schema) if you are connected with another database. More information can be found [here](Can I do multi-database or cross-database queries with Firebird?.