I import a UTF16 customer file from SAP BW, on a daily basis, into a staging table (SQL 2008R2).
We have a requirement to extract data without unicode characters.
I would like to replace unicode characters with the Latin equivalent.
à -> a
ś -> s
ï -> i
æ -> ae
Some data may be malformed and I'd also like to clean it up:
Sa³ley Ma¶ller -> Soley Moller
Trois-RiviÃ?Â¨res -> Trois-Rivieres
Here is current collation:
SELECT SERVERPROPERTY('Collation') --SQL_Latin1_General_CP1_CI_AS
Thank you for looking at this.