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)
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?
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.
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.