Differences between dialect1 and dialect3 in Firebird

Source: Internet
Author: User
Tags integer division

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;

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.