Multi language columns in a table?

Tools

Multi language columns in a table?

Hi All,

I guess Teradata supports multi language.
Here is my reqiurement. In a table I want one column to store data in English and the other column in some other language say Arabic. The table should be like this.

AccID Add1 Add2
-----------------------------
AB12 ****** ****** (in Arabic)
CD43 ****** ****** (in Arabic)

Is this possible in TD?

5 REPLIES
Enthusiast

Re: Multi language columns in a table?

As long as you stick to Unicode with your Arabic data, you should be able to define those columns as unicode and use it.

..........

Add1 VARCHAR(30) CHARACTER SET UNICODE

Re: Multi language columns in a table?

Hi Supreme Being
Thanks for your reply.
do you mean to say column "Addid" can have data in English with normal data type and columns "Add1 and Add2" are of data type UNICODE and can hold data in Arabic? That is, two languages in one table?
Enthusiast

Re: Multi language columns in a table?

That's true you can have both kind of columns in the same table, And TD don't care if it's Arabic or Chinese or any language that matter, when the column definition says UNICODE, it means it can contain any valid Unicode values.

Re: Multi language columns in a table?

Hi Supreme Being,

Thanks a lot, Guru.

Enthusiast

Re: Multi language columns in a table?

Hi,

Just want to get some more clarification on this.Ex If i have a table with 2 cols one with normal character set and other with unicode and I extract the data using Fast export and '|' delimiter, Do i have to take any special care for unicode columns.

Thanks
Ashish