Ispirer Ispirer
 


Ispirer Home Page Ispirer SQLWays Product Page Request SQLWays

Interbase/Firebird - Identifiers

This article describes identifiers in Interbase/Firebird.

Identifier Rules

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

Quoted or Delimited Identifiers

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


Ispirer Home Page Ispirer SQLWays Product Page Request SQLWays

sqlways/interbase-firebird/identifiers.txt · Last modified: May 07, 2018, 03:15:28 PM (external edit)
 
© 1999-2018, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement