All Forums Database
nagendratrpth 25 posts Joined 03/14
06 Jul 2015
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

nagendratrpth 25 posts Joined 03/14
13 Jul 2015

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

Glass 225 posts Joined 04/10
13 Jul 2015

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

You must sign in to leave a comment.