How to convert column character set in Teradata table.

Database

How to convert column character set in Teradata table.

Hi ,

My Requirement is that i want to change character set of a column. For some tables, i want to change columns character set  from Latin to Unicode and for some other tables from Unicode to Latin.

Is there any command available which i can execute in SQL Assistant directly with out drop and recreating table. Its very urgent .Please help.

1 REPLY
Teradata Employee

Re: How to convert column character set in Teradata table.

No. You cannot ALTER an existing column in a manner that requires rewriting the data rows.

For non-indexed columns, you can use ALTER to rename existing columns and/or add new columns (e.g. ALTER RENAME existing column, ALTER ADD new column with original name, UPDATE to copy data from one column to the other, ALTER DROP the old column).

Or you can rename the existing table, create a new table with the original name, insert/select the data, define any additional indexes, etc. on the new table, and drop the old table.