uCosminexus Stream Data Platform - Application Framework Application Development Guide

[Contents][Index][Back][Next]

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. Type Characters that can be used
1 Name Single-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.
2 Character string constant Single- and double-byte characters can be used.
3 Other types Single-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