16.20 - Effects of Object Naming on SPECCHAR Controls - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Syntax and Examples

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Content Type
Programming Reference
Publication ID
B035-1144-162K
Language
English (United States)
Last Update
2019-05-24
The Password SpecChar control includes some additional character effects:
  • Upper includes all UNICODE characters in General Category Class Lu.
  • Lower includes all UNICODE characters in General Category Class Ll.
  • Alpha includes all UNICODE characters that are in either Upper (Lu) or Lower (Ll)
  • Special indicates characters that are neither Alpha nor any of the characters 0 through 9 (U+0030 – U+0039). By this definition, uncased letters (General Category Class Lo) are considered Special (for example, Arabic, Chinese or Hebrew characters). Likewise numeric digits (General Category Class Nd) other than the characters 0 through 9 (U+0030 – U+0039) are classified as Special.

For consistency in handling characters, the system checks Password SpecChar based on the NFC (Normalization Form C) representation of the password string. For example, the character ‘é’ (U+00E9) is a Special, a Lower, and an Alpha character.

For details, see “Password Formatting and Object Name Validation” in Teradata Vantage™ NewSQL Engine Security Administration, B035-1100.