'Declaration
 
Public Property SessionCharacterSet As String

'Usage
 
Dim instance As TdConnectionStringBuilder
Dim value As String
 
instance.SessionCharacterSet = value
 
value = instance.SessionCharacterSet

public string SessionCharacterSet {get; set;}

public:
property String^ SessionCharacterSet {
   String^ get();
   void set (    String^ value);
}

Property Value

Default value is ASCII.

The Data Provider encodes Unicode characters to bytes before it sends character data to Advanced SQL Engine. Data Provider also decodes bytes to Unicode characters when it receives character data from the SQL Engine. Data Provider will create an instance of Text.Encoding class initialized with Windows Code Page corresponding to Teradata Session Character set as described below.

Data Provider supports the following Session Character Sets and the corresponding Windows Code Pages:

the Advanced SQL Engine supports LATIN, UNICODE and KANJISJIS Server Character Sets. UTF8 and UTF16 Session Character Sets are compatible with all Server Character Sets. LATIN1252_3A0 is compatible with LATIN and UNICODE Server Character Sets. KANJI932_1S0 Session Character Set is compatible with UNICODE Server Character Sets. The remaining Session Character Sets are compatible with UNICODE Sever Character Set. ASCII is compatible with LATIN, UNICODE and KANJISJIS as long as character code-points are within the ASCII range.

The KANJISJIS_0S character set includes all the characters in the JIS X 0201 and JIS X 0208 standards, plus extensions, including single-byte Hankaku Katakana characters and multi-byte Kanji characters. KANJISJIS_0S is not 100% compatible with the latest Windows code page 932 as the mapping to Unicode is different for several Japanese characters including the Yen symbol. Therefore, the best practice is to use KANJI932_1S0, UTF8 or UTF16 Session Character Sets with the UNICODE Server Character Set.

The International Character Set Support manual has additional information about Windows compatible session character sets. The manual describes how to enable one or more of the session character sets. Windows compatible session character sets are disabled by default.

Reference

TdConnectionStringBuilder Class
TdConnectionStringBuilder Members