User Documentation
Ispirer Capabilities - Interbase Migration
Pricing
This article describes identifiers in Interbase/Firebird.
| Interbase/Firebird - Identifier Rules | |
|---|---|
| First Character | An alphabetical character |
| Subsequent Characters | Alphanumeric characters, underscore (_) and dollar sign ($) |
| Maximum Length | 67 characters Constraint names are restricted to 27 characters |
| Case Sensitivity | Identifiers are case insensitive |
| Standards | ANSI SQL |
Identifiers - Differences between Interbase/Firebird and other Databases
| Database | Identifiers | First Character | Subsequent Characters | Max Length |
|---|---|---|---|---|
| Oracle | Oracle Identifiers | No differences | Allowed: # | 30 |
| SQL Server | SQL Server Identifiers | Allowed: _, @ and # | Allowed: @ and # | 128 |
| IBM DB2 | IBM DB2 Identifiers | No differences | Not allowed: $ | 128 |
| MySQL | MySQL Identifiers | Allowed: digit | No differences | 64 |
| PostgreSQL | PostgreSQL Identifiers | Allowed: _ | No differences | 63 |
| Sybase ASE | Sybase ASE Identifiers | Allowed: _, @ and # | Allowed: @ and # | 255 |
| Sybase ASA | Sybase ASA Identifiers | Allowed: _, @, $ and # | Allowed: @ and # | 128 |
| Informix | Informix Identifiers | Allowed: _ | No differences | 128 |
| Teradata | Teradata Identifiers | Allowed: _, $ and # | Allowed: # | 30 |
| HP Neoview | HP Neoview Identifiers | No differences | Not allowed: $ | 128 |
| Interbase/Firebird - Quoted Identifiers | |
|---|---|
| Quotation Marks | Double quotation marks (“”) |
| Characters | Any character except space(s) as the last character(s) |
| Maximum Length | 67 characters, not including the quotation marks Constraint names are restricted to 27 characters |
| Case Sensitivity | Case sensitive. For example, “tab 1” and “Tab 1” are considered as different identifiers |
| Notes | Case sensitivity depends on the Dialect of the database. For 3 and higher the delimited identifiers are case sensitive. |
Quoted Identifiers - Differences between Interbase/Firebird and other Databases
| Database | Identifiers | Quotation Marks | Characters | Case Sensitivity |
|---|---|---|---|---|
| Oracle | Oracle Quoted Identifiers | “” | Any except quotes | Case sensitive |
| SQL Server | SQL Server Quoted Identifiers | [] and “” | Any except quotes | Case insensitive |
| IBM DB2 | IBM DB2 Quoted Identifiers | “” | Any including quotes | Case sensitive |
| MySQL | MySQL Quoted Identifiers | `` and “” | Any except quotes | Case sensitive |
| PostgreSQL | PostgreSQL Quoted Identifiers | “” | Any including quotes | Case sensitive |
| Sybase ASE | Sybase ASE Quoted Identifiers | [] and “” | Any except pound sign (#) as the first character | Case insensitive |
| Sybase ASA | Sybase ASA Quoted Identifiers | [] and “” | Any | Case insensitive |
| Informix | Informix Quoted Identifiers | “” | Any including quotes | Case sensitive |
| Teradata | Teradata Quoted Identifiers | “” | Any including quotes | Case insensitive |
| HP Neoview | HP Neoview Quoted Identifiers | “” | Any except at sign (@), forward slash (/), circumflex character (^) as the first character and space(s) as the last character(s) | Case sensitive |