|
|
|
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);
