Specify quoted strings

You use quoted strings in various SQL statements, particularly data manipulation statements such as SELECT and INSERT.

A quoted string is a string of consecutive characters that is delimited by quotation marks. The marks can be single quotation marks or double quotation marks. If the DELIMIDENT environment variable is set, however, the database server interprets a string of characters in double quotation marks as a delimited identifier rather than as a string. For more information about delimited identifiers, see Non-ASCII characters in identifiers.

When you use a nondefault locale, you can use any characters in the code set of your locale within a quoted string. If the locale supports a code set with non-ASCII characters, you can use these characters in a quoted string. In the following example, the user inserts column values that include multibyte characters in the table mytable:

INSERT INTO mytable
   VALUES ('A¹A2B¹B²abcd', '123X¹X²Y¹Y²', 'efgh')

In this example, the first quoted string includes the multibyte characters A¹A² and B¹B². The second quoted string includes the multibyte characters X¹X² and Y¹Y². The third quoted string contains only single-byte characters. This example assumes that the locale supports a multibyte code set with the A¹A², B¹B², X¹X², and Y¹Y² characters.

For a description of quoted strings, see the Quoted String segment in the HCL OneDB Guide to SQL: Syntax.