Tidy badly encoded DB TABLE french chars

These few SQL lines came in handy when wanting a quick-fix for a poorly imported table

UPDATE [rpt].[dbo].[vapProducts] SET Region = replace(Region,'Á©','é')

UPDATE [rpt].[dbo].[vapProducts] SET Region = replace(Region,'Á´','ô')

UPDATE [rpt].[dbo].[vapProducts] SET Region = replace(Region,'ÁŽ','Î')



http://stackoverflow.com/questions/5127744/how-to-convert-these-strange-characters-%C3%83-%C3%83-%C3%83%C2%AC-%C3%83%C2%B9-%C3%83


Comments

Popular posts from this blog

How do you fix a roll of aluminium foil once it's started spiralling?

Why does Premiere Pro "Sequence from clip" on MP4 and then "Match Sequence" result in a massive AVI file?

Churchill's Reaction to Eisenhower's Speech at the English Speaking Union 1951