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

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