1
ThumbsPlus v10 Questions / Adding Unicode support to existing SQL Server Database
« on: 2016-03-06 04:44:30 »
I looked at the most recent database creation script. It looks like all old varchar columns should now be nvarchar. This explains (obviously) the issue I described with find in my previous post.
My problem is that from what I have seen an existing column cannot just be converted without dropping the table and recreating it (which is not a good thing if it is already populated with data).
I had to do it by creating a new column, copying over from the old column, renaiming old to new, deleting the old one and dealing with eventual indexes.
Does anybody have a script to do this??? Maybe Cerious has a script to convert an older database???
My problem is that from what I have seen an existing column cannot just be converted without dropping the table and recreating it (which is not a good thing if it is already populated with data).
I had to do it by creating a new column, copying over from the old column, renaiming old to new, deleting the old one and dealing with eventual indexes.
Does anybody have a script to do this??? Maybe Cerious has a script to convert an older database???