Purpose
Determines whether additional rules are used by Teradata Database to validate object names.
Field Group
General
Valid Settings
| Setting | Description |
|---|---|
| 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. |
Default
0
Changes Take Effect
After the next Teradata Database restart for new objects. Objects created prior to changing this setting are unaffected by the change.
Related Topics
| 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. |