3.1.2 Characters that can be used in CQL

This subsection explains the characters that can be used in CQL.

Organization of this subsection
(1) Character code that can be used
(2) Characters that can be used

(1) Character code that can be used

The only character code that can be used in CQL is MS932.

(2) Characters that can be used

The following table shows the characters that can be used in CQL.

Table 3-1 Characters that can be used in CQL

No.TypeCharacters that can be used
1NameSingle-byte alphanumeric characters and the underscore (_) can be used. However, a name must start with a single-byte alphanumeric character. For details about name specification, see 3.2.4 Specifying names.
2Character string constantSingle- and double-byte characters can be used.
3Other typesSingle-byte characters and the special symbols listed below can be used.
  • Single-byte characters
    Uppercase letters (A to Z), lowercase letters (a to z), numbers (0 to 9), spaces, and underscore (_)
  • Special symbols
    Comma (,): Selection lists, value expressions, and the like
    Period (.): Floating-point constants, column specifications, date/time data, and the like
    Colon (:): Time, timestamp data
    Hyphen (-): Date, timestamp data
    Single quotation mark ('): To enclose a character string
    Left parenthesis (() and right parenthesis ()): Relation expressions, to enclose cast specifications, and so on
    Less than operator (<), greater than operator (>), equal to operator (=), and exclamation mark (!): Comparative operators
    Plus sign (+), minus sign (-), and forward slash (/): Arithmetic operators
    Asterisks (*): Arithmetic operator, whole column output, etc.
    Semicolon (;): Statement delimiter
    Square brackets ([ ]): Enclosing tab code for time specifications, line feed code, carriage return code
    Two forward slashes (//): Comments