Create UTF-8 database?

Database
qiu
N/A

Create UTF-8 database?

Hello expers,

I am newcommer of Teradata database. Could you tell me how to create a database with UTF-8 support in detail?

Thanks,
Hao
1 REPLY
Teradata Employee

Re: Create UTF-8 database?

Teradata supports Server (Column) Character Sets and Session Character Set.

The Server/Column Character Sets are:
LATIN
UNICODE
GRAPHIC
KANJI1
KANJISJIS

For example:
Create Table Foo (C01 Integer, C02 VarChar(100) Character Set UNICODE );

See "SQL Reference: Data Types and Literals" for Server Character Sets.

Teradata Database converts Server Character Set to Session Character Set. Session Character set is associated with each session and specified by the application.

Session Character Set can be set to UTF8, UTF16, ASCII, KANJISJIS_0S and others.

See "International Character Set Support" for Client Character sets.