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:
   VALUES ('A1A2B1B2abcd', '123X1X2Y1Y2', 'efgh')

In this example, the first quoted string includes the multibyte characters A1A2 and B1B2. The second quoted string includes the multibyte characters X1X2 and Y1Y2. The third quoted string contains only single-byte characters. This example assumes that the locale supports a multibyte code set with the A1A2, B1B2, X1X2, and Y1Y2 characters.

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