Difference between client character set and server
character set? What is the use of these two?default
character set in teradata?



Difference between client character set and server character set? What is the use of these two?def..

Answer / rajesh kuruva

I read in one blog and posting here.

There are two categories of character sets in Teradata terminology:

Server Character Sets
Client Character Sets

Teradata is a truly multi-language database. That said, it has to have the ability to receive, process, store and return character data of all kinds. To that end, there come the two kinds of character sets. Server character sets are used for internal processing (like doing data retrieval or joining) and storage, while client character sets are used for converting incoming character data to the server character set (like issuing a query in BTEQ or SQL Assistant), and vice versa (like receiving result from BTEQ or exporting to an external file).

Server Character Sets

There are five supported server character sets:
LATIN
UNICODE
KANJISJIS
GRAPHIC
KANJI1 (deprecated)
The default server character set can be specified in the CREATE USER or MODIFY USER statement. If not specified, the server character set will by default be UNICODE for Japanese system and LATIN for all others.
CREATE USER dba1 AS PASSWORD=... PERM=... DEFAULT CHARACTER SET LATIN;

LATIN is mainly used by the ASCII client character set users. UNICODE is designed for storing ALL the characters in ALL languages in the world. KANJISJIS is a canonical character set for Japanese applications. GRAPHIC is designed for IBM DB2 compatibility.

Client Character Sets

There are more than 20 supported client character sets:
ASCII
EBCDIC
UTF8
UTF16
Japanese character sets
Chinese character sets
Korean character sets
Other single-byte international character sets
There's no limit on how many client character sets can be installed, but only 16 client character sets can be active at the same time. Only one client character set can be set as the default active character set, using the following BTEQ command:
.set session charset [CHARSET]
CHARSET can be one of the supported client character sets.

ASCII, EBCDIC, UTF8 and UTF16 are predefined and automatically supported for all configurations. In ASCII, each byte represents one character. It's the same for EBCDIC, while EBCDIC is only available for channel-attached clients. In UTF8, a character can consist of one to three bytes. In UTF16, each character is composed of two bytes.

Is This Answer Correct ?    7 Yes 0 No

Post New Answer

More Teradata Interview Questions

How to handle nulls in Teradata??? How many columns can be there in a table??? How to find average sal with out using avg function????

3 Answers   Mphasis,


How would you load a very large file in teradata in general? What utility would you use for it? Why?

0 Answers  


how do you handle ET and UV errors ?

2 Answers  


What is meant by a Channel Driver?

0 Answers  


Hi frnds...can any one help me regarding this que.. We have column in a table name it as C1 WHICH CONTAIN ALPHANUMERIC AND NUMERIC VALUES. C1 2A 2B 2V 2H 1 2 3 4 5 i want to retrive numeric values like 1,2,3,4,5 How we can get Plz let me know.Thanks in advance

4 Answers   IBM,


Highlight a few of the advantages that ETL tools have over Teradata.

0 Answers  


Which is more efficient group by or distinct to find duplicates?

0 Answers  


What is teradata? Also, list out some of the primary characteristics of teradata.

0 Answers  


What is the difference between SI and JI?

2 Answers  


Give a justifiable reason why Multi-load supports NUSI instead of USI.

0 Answers  


What is spool space? Why do you get spool space errors? How do trouble-shoot them?

0 Answers  


what are the uses of fact table and dimension table in banking project?

0 Answers   TCS,


Categories