TD Multi language support

General
Enthusiast

TD Multi language support

Hi,

we have a flat file with comments column having multiple languages like [greek,french,chineese].

Is it possible to store different formats in a varchar field?

If I select the data from the table, will it be displayed in the correct format?

Thanks,

Karthik. N

3 REPLIES
Senior Apprentice

Re: TD Multi language support

The flat file is probably in Unicode, so just create the comment column using CHARACTER SET UNICODE.

Dieter

Enthusiast

Re: TD Multi language support

Thanks Dieter!

Is it possible to convert existing column with CHARACTER SET LATIN to  CHARACTER SET UNICODE?

Thanks,

Karthik. N

Junior Supporter

Re: TD Multi language support

Karthik:

"ALTER TABLE does not support changing the server character set for character data types." (Failure 3558 Cannot alter the specified attribute(s) for)

Maybe you'll find some help here:

http://downloads.teradata.com/download/tools/unicode- tool-kit

HTH.

Cheers.

Carlos.