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,'ÁŽ','Î')
Comments
Post a Comment