15.10 - Effects of Object Naming on SPECCHAR Controls - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

prodname
Teradata Database
vrm_release
15.10
created_date
December 2015
category
Programming Reference
featnum
B035-1144-151K
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 Security Administration, B035-1100.