SQL Reference Guide

Delimited Identifiers

Delimited identifiers are FairCom DB SQL object names enclosed in double quotation marks (""). Enclosing a name in double quotation marks allows it to include UTF-8 characters or be a reserved SQL word. By default, the server does not preserve the case of the name, which ensures the ASCII characters in the name are case-insensitive. Subsequent references to a delimited identifier must also use enclosing double quotation marks. To include a double-quotation-mark character in a delimited identifier, precede it with another double quotation mark.

The following FairCom DB SQL example shows several ways to create and refer to delimited identifiers:

CREATE TABLE "delimited ids"

( """" CHAR(10),

"_uscore" CHAR(10),

"""quote" CHAR(10),

" space" CHAR(10) );

INSERT INTO "delimited ids" ("""") VALUES('text string');

1 record inserted.

SELECT * FROM "delimited ids";

" _USCORE "QUOTE SPACE

- ------- ------ ------

text string

1 record selected

CREATE TABLE "TABLE" ("CHAR" CHAR);