Data Model > Accessing the UNICOM Intelligence Data Model > Working with the Case Data Model > General information > Rules for regular identifiers
 
Rules for regular identifiers
The first character must be one of the following:
A letter as defined by the Unicode Standard 3.0. The Unicode definition of letters includes Latin characters a-z and A-Z, in addition to letter characters from other languages.
The _ (underscore) symbol.
Subsequent characters can be:
Letters as defined in the Unicode Standard 3.0.
Decimal numbers from either Basic Latin or other national scripts.
The @, $, #, or _ symbols.
General rules are:
The identifier can be an SQL reserved word. The Provider reserves both the uppercase and lowercase versions of reserved words. For more information, see Reserved keywords.
Embedded spaces or special characters are not allowed.
Any identifier that does not comply with all of these rules must always be delimited by double quotation marks or brackets when used in Provider SQL statements.
Note The Unicode Standard 3.0 definition of a letter is "An informative property that applies to characters that are used to write words. This group includes characters such as capital letters, small letters, ideographs, hangul, and spacing modifier letters." Refer to the Unicode Standard 3.0 CD-ROM for the letter property mappings.
See also
Locale handling in the UNICOM Intelligence Data Model
Identifier naming conventions
Data types
Data type conversions
System variables