|
|
|
Delimited identifiers are FairCom DB SQL identifiers enclosed in double quotation marks (""). Enclosing a name in double quotation marks, by default, preserves the case of the name and allows it to be a reserved word and special characters. (Special characters are any characters other than letters, digits, or the underscore character.) 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);
