3
I don’t understand very well with these database deals but it made me curious these SQL dialect.
- What SQL dialect?
- What is the difference between SQL dialect 1 and SQL dialect 3?
- And what’s the point?
2 answers
5
Firebird supports 3 SQL dialects on both server and client. These differ in date-time format and number accuracy. Dialects serve to instruct the firebase server on how to process legacy Borland Interbase functions prior to version 6.0. Dialects are configured in Runtime and can be exchanged by the client at the time of connection or with the SET SQL DIALECT command, table illustrating the differences:
Note: Currently it is only possible to create databases in dialect 1 and 3, and version 3 is recommended, because version 1 will eventually be discontinued, dialect 2 cannot be used to create databases, as it only serves to convert the dialect from version 1 to 3.
5
It’s not about SQL itself, it’s about Firebird. At some point the product concluded that something he was doing was wrong and decided to do it differently, but very little has changed. But a lot of people were used to the old way, have codes that use the old way, so you can have different forms of it act according to your need.
Differences:
Browser other questions tagged sql firebird
You are not signed in. Login or sign up in order to post.