Differences between dialect1 and dialect3 in Firebird

1. dialects 1 and 3 store different fixed points, and the floating point Double Precision type is also different.
2. the maximum value of the generator (serial number) in dialects 1 and 3 modes is different. One is 32-bit, and the other is 64-bit.
3. dialects 1 and 3 have different arithmetic operation modes. In the three categories, the integer division operator, and in the one categories, the integer division may obtain decimal places (if not all Division)
4. The date types of dialects 1 and 3 are somewhat different. One has a time and the other has a bald date.
5. dialects 3 supports the time type, but 1 does not.
6. dialects 1 and 3. Three types support the conversion of standard SQL strings with quotation marks. It seems that Class 1 must be forcibly converted.
7. dialects 1 and 3. SQL quotes are single quotes. Double quotation marks are allowed for Category 1 and double quotation marks for Category 3.
8. dialects 1 and 3. The three types have more reserved words.CodeIf the token is correct, an error may be reported in three categories due to reserved words.
9. dialects 1 and 3. The three types have strict type conversion, or seem to be strongly typed. Converting one type of SQL code to three types may be a big headache.

Dialect 1 does not support some items, such as date type and bigint type;