SQL Dialect Matrix

Relationship Between Client SQL V's Database SQL

Client SQL dialect 1
Feature Database SQL Dialect 1 Database SQL Dialect 2 Database SQL Dialect 3
Any thing Delimited by double quotes (non DDL) String constant String constant String constant
Any thing Delimited by double quotes (DDL) String constant Error Error
Date Time stamp Time stamp Time stamp
Date as DDL Time stamp Error Error
SQL date, Time, timestamp Ok Ok Ok
64-bit numeric ??? ??? ???

Client SQL dialect 2
Feature Database SQL Dialect 1 Database SQL Dialect 2 Database SQL Dialect 3
Any thing Delimited by double quotes (non DDL) Error Error Error
Any thing Delimited by double quotes (DDL) Error Error Error
Date Error Error Error
Date as DDL Error Error Error
SQL date, Time, timestamp Ok Ok Ok
64-bit numeric ??? ??? ???

Client SQL dialect 3
Feature Database SQL Dialect 1 Database SQL Dialect 2 Database SQL Dialect 3
Any thing Delimited by double quotes (non DDL) Delimited ID Delimited ID Delimited ID
Any thing Delimited by double quotes (DDL) Error Error Ok
Date Date Date Date
Date as DDL Error Error Date
SQL date, Time, Timestamp Ok Ok Ok
64-bit numeric ?? ??? ???