SQL Dialect Matrix
Relationship Between Client SQL V's Database SQL
| 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 | ??? | ??? | ??? |
| 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 | ??? | ??? | ??? |
| 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 | ?? | ??? | ??? |