Teradata Sesstion char set changing

UDA

Teradata Sesstion char set changing

Hi,

I am using the Teradata DB version12.

I need to login to the DB using the DSN(say TD12) created to Teradata DB with the “Session Character set” set to LATIN_01A

I ran the command “update DBC.CharTranslations set installFlag='Y' where installFlag='N'” to enable the LATIN support to the DB

Please correct me if I am wrong here.

I restarted the TD DB Service also,

Even then I wm not able to login to the DB using the DSN (say TD12) as said above.

Is there any way that I could confirm that the LATIN support is enabled on Teradata DB
1 REPLY

Re: Teradata Sesstion char set changing

I believe you need to add a row in dbc.hosts for the default character set.

in dbc.chartranslations table at a time maximum of 12 charactersets can be enabled.

correct me if i am wrong.

regards,
raja.