Effects of Object Naming on SPECCHAR Controls - Teradata Vantage - Analytics Database

SQL Data Definition Language Syntax and Examples

Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2025-11-22
dita:mapPath
jco1628111346878.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
mdr1472255012272
lifecycle
latest
Product Category
Teradata Vantage™
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 Teradata Vantage™ - Analytics Database Security Administration, B035-1100.