Determines whether additional rules are used by Teradata Database to validate object names.
|0||No additional name validation is performed beyond basic validation rules.|
|1||Name validation rules used in pre-14.10 releases.|
|2||Name validation using a minimal character set:
'A' - 'Z', 'a' - 'z', '0' - '9', '#', '$', and '_'
|62||Name validation using the UTF16 client character set.|
|63||Name validation using the UTF8 client character set.|
|64||Name validation using the EBCDIC client character set.|
|65 through 126||Name validation using a user-defined character set.|
|127||Name validation using the ASCII client character set.|
Changes Take Effect
After the next Teradata Database restart for new objects. Objects created prior to changing this setting are unaffected by the change.
|For more information on...||See...|
|Basic object naming rules||SQL Fundamentals.|
|System language support mode||System Initializer (sysinit) chapter in Support Utilities.|
|User-defined character sets||International Character Set Support.|