Both sides previous revisionPrevious revision | |
sqlways:db2:identifiers [September 01, 2009, 10:50:32 AM] – leonov | sqlways:db2:identifiers [May 31, 2023, 05:28:08 PM] (current) – external edit 127.0.0.1 |
---|
| |
\\ | \\ |
[[http://www.ispirer.com/products/db2-migration|SQLWays Product Page - Migration to IBM DB2]] | [[https://www.ispirer.com|Ispirer Website]] |
[[http://www.ispirer.com/download|Free Evaluation]] | [[https://www.ispirer.com/products/db2-migration|Ispirer Capabilities - DB2 Migration]] |
| [[https://www.ispirer.com/download/download-demo|Free Trial]] |
\\ | \\ |
| |
| **SQL Server** | [[sqlways:sql-server/identifiers|SQL Server Identifiers ]] | Allowed: _ , @ and # | Allowed: $, @ and # | 128 | | | **SQL Server** | [[sqlways:sql-server/identifiers|SQL Server Identifiers ]] | Allowed: _ , @ and # | Allowed: $, @ and # | 128 | |
| **MySQL** | [[sqlways:mysql/identifiers|MySQL Identifiers ]] | Allowed: digit | Allowed: $ | 64 | | | **MySQL** | [[sqlways:mysql/identifiers|MySQL Identifiers ]] | Allowed: digit | Allowed: $ | 64 | |
| **Sybase ASE** | [[sqlways:sybase/identifiers|Sybase ASE Identifiers ]] | Allowed: _ , @ and # | Allowed: $, @ and # | 255 | | |
| **PostgreSQL** | [[sqlways:postgresql/identifiers|PostgreSQL Identifiers ]] | Allowed: _ | Allowed: $ | 63 | | | **PostgreSQL** | [[sqlways:postgresql/identifiers|PostgreSQL Identifiers ]] | Allowed: _ | Allowed: $ | 63 | |
| | **Sybase ASE** | [[sqlways:sybase/identifiers|Sybase ASE Identifiers ]] | Allowed: _ , @ and # | Allowed: $, @ and # | 255 | |
| | **Sybase ASA** | [[sqlways:sybase/asa-identifiers|Sybase ASA Identifiers ]] | Allowed: _ , $, @ and # | Allowed: $, @ and # | 128 | |
| | **Informix** | [[sqlways:informix/identifiers|Informix Identifiers ]] | Allowed: _ | Allowed: $ | 128 | |
| | **Teradata** | [[sqlways:teradata/identifiers|Teradata Identifiers ]] | Allowed: _, $ and # | Allowed: $ and # | 30 | |
| | **HP Neoview** | [[sqlways:neoview/identifiers|HP Neoview Identifiers ]] | No differences | No differences | 128 | |
| | **Interbase/Firebird** | [[sqlways:interbase-firebird/identifiers|Interbase/Firebird Identifiers ]] | No differences | Allowed: $ | 67 | |
| |
| |
===== Quoted or Delimited Identifiers ===== | ===== Quoted or Delimited Identifiers ===== |
| **Oracle** | [[sqlways:oracle/identifiers#quoted_or_delimited_identifiers|Oracle Quoted Identifiers ]] | "" | Any except quotes | Case sensitive | | | **Oracle** | [[sqlways:oracle/identifiers#quoted_or_delimited_identifiers|Oracle Quoted Identifiers ]] | "" | Any except quotes | Case sensitive | |
| **SQL Server** | [[sqlways:sql-server/identifiers#quoted_or_delimited_identifiers|SQL Server Quoted Identifiers ]] | [] and "" | Any except quotes | Case insensitive | | | **SQL Server** | [[sqlways:sql-server/identifiers#quoted_or_delimited_identifiers|SQL Server Quoted Identifiers ]] | [] and "" | Any except quotes | Case insensitive | |
| **MySQL** | [[sqlways:mysql/identifiers|MySQL Identifiers ]] | `` and "" | Any except quotes | Case sensitive | | | **MySQL** | [[sqlways:mysql/identifiers#quoted_or_delimited_identifiers|MySQL Quoted Identifiers ]] | `` and "" | Any except quotes | Case sensitive | |
| **Sybase ASE** | [[sqlways:sybase/identifiers#quoted_or_delimited_identifiers|Sybase ASE Quoted Identifiers ]] | [] and "" | Any except quotes | Case insensitive | | |
| **PostgreSQL** | [[sqlways:postgresql/identifiers#quoted_or_delimited_identifiers|PostgreSQL Quoted Identifiers ]] | "" | Any including quotes | Case sensitive | | | **PostgreSQL** | [[sqlways:postgresql/identifiers#quoted_or_delimited_identifiers|PostgreSQL Quoted Identifiers ]] | "" | Any including quotes | Case sensitive | |
| | **Sybase ASE** | [[sqlways:sybase/identifiers#quoted_or_delimited_identifiers|Sybase ASE Quoted Identifiers ]] | [] and "" | Any except pound sign (#) as the first character | Case insensitive | |
| | **Sybase ASA** | [[sqlways:sybase/asa-identifiers#quoted_or_delimited_identifiers|Sybase ASA Quoted Identifiers ]] | [] and "" | Any | Case insensitive | |
| | **Informix** | [[sqlways:informix/identifiers#quoted_or_delimited_identifiers|Informix Quoted Identifiers ]] | "" | Any including quotes | Case sensitive | |
| | **Teradata** | [[sqlways:teradata/identifiers#quoted_or_delimited_identifiers|Teradata Quoted Identifiers ]] | "" | Any including quotes | Case insensitive | |
| | **HP Neoview** | [[sqlways:neoview/identifiers#quoted_or_delimited_identifiers|HP Neoview Quoted Identifiers ]] | "" | Any except at sign (@), forward slash (/), \\ circumflex character (<html>^</html>) as the first character \\ and space(s) as the last character(s) | Case sensitive | |
| | **Interbase/Firebird** | [[sqlways:interbase-firebird/identifiers#quoted_or_delimited_identifiers|Interbase/Firebird Quoted Identifiers ]] | "" | Any character except space(s) as the last character(s) | Case sensitive | |
| |
\\ | |
[[http://www.ispirer.com/products/db2-migration|SQLWays Product Page - Migration to IBM DB2]] | |
[[http://www.ispirer.com/download|Free Evaluation]] | |
| |