Alter table for VARCHAR(4000) Latin to UNicode

Database
Enthusiast

Alter table for VARCHAR(4000) Latin to UNicode

Hi,

I want to alter my table column from VARCHAR(4000) Latin to Unicode .

Please help with the alter table syntax if feasible or any differnt approch for the same.

Thanks

Nagendra

Tags (1)
2 REPLIES
Enthusiast

Re: Alter table for VARCHAR(4000) Latin to UNicode

Do we have alter option for this change or rename & then recreate is the only way.

Thanks in advance.

Nagendra

Enthusiast

Re: Alter table for VARCHAR(4000) Latin to UNicode

Nagendra,

If you don't want to drop and recreate the table you could add a new Unicode column,

Update it with the contents of Latin column, then drop the Latin column and rename the Unicode to original name.

 

 

Rglass