Object names are stored in the data dictionary in UNICODE. For more information, about Teradata support for UNICODE, see UNICODE Server Character Set.
Specification of object names is subject to these character usage rules:
- The rules are based on Object Naming Controls, which define allowable characters.
- You can specify an object name as a regular identifier, that is, without quotation mark delimiters, if the name uses only characters in the current character repertoire.
- You can specify an object name as a delimited identifier, using characters outside the current character repertoire. You can use quotation marks to include an odd character, such as a comma, inside an object name. However, to get characters outside the current character repertoire in an object name, you must use a special name literal, which does have quotation marks as part of its syntax.
- Certain characters are explicitly disallowed from appearing in object names.