16.20 - Examples - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Functions, Expressions, and Predicates

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1145-162K

The following statement applies the CHARACTER_LENGTH function to the Name column, which is type VARCHAR(30) CHARACTER SET LATIN, to obtain the number of characters in each employee name:

   SELECT Name, CHARACTER_LENGTH(Name) 
   FROM Employee; 

The result is as follows (note that separator blanks are considered characters):

   Name      Character_Length(Name)
   --------  ----------------------
   Smith T            7
   Newman P           8
   Omura H            7
         .            .

Example Set 1: KanjiEBCDIC

FOR this server character set … AND example … CHARACTER_LENGTH returns …
GRAPHIC ABC 3
KANJI1 De<MNP > 10
<><> 4

Set 2: KanjiShift-JIS

FOR this server character set … AND example … CHARACTER_LENGTH returns …
KANJI1 <><> 10
D eF 3
UNICODE ABC 3
GRAPHIC ABC 3

Set 3: KanjiEUC

FOR this server character set … AND example … CHARACTER_LENGTH returns …
KANJI1 ss3 C ss3 D 2
GRAPHIC 2
UNICODE <><> 0
dA ss2 B ss3 E 4
LATIN ABC 3