The UTF-8 characters (nearly a million records) were imported into varchar(max) as western european. Is there any known method of fixing this in SQL? We have verified that the "garbage" characters that are showing up are, in fact, based on the incorrect characters in the Western European encoding representing the UTF-8 hexidecimal values. It would seem that the underlying hexidecimal in varchar field is correct. Ideally we would like to be able to fix this in SQL rather than re-importing the data.
Asked
Active
Viewed 1,529 times