Delimited Identifiers (Metadata Names)

From InterBase
Jump to: navigation, search

In InterBase dialect 1, object names are not case sensitive, cannot be keywords, and cannot contain spaces or non-ASCII characters.

In dialect 3, object names that are enclosed in double quotes are delimited identifiers. They are case sensitive, can be keywords, and can contain spaces and non-ASCII characters. For example:

SELECT “CodAR” FROM MyTable

is different from:

SELECT “CODAR” FROM MyTable

This behavior conforms to ANSI SQL semantics for delimited identifiers.