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,'ÁŽ','Î')



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?

Distributed Backlink Service