All Forums Database
nagendratrpth 25 posts Joined 03/14
06 Jul 2015
Alter table for VARCHAR(4000) Latin to UNicode

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.

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.

Glass 225 posts Joined 04/10
13 Jul 2015

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.

You must sign in to leave a comment.