UTF-8 to ISO-8859-1 conversion
Moderators: chulett, rschirm, roy
UTF-8 to ISO-8859-1 conversion
I've got a nvarchar in SQL Server (reads work with UTF-8) and want to output it to ISO-8859-1. Unfortunately not all UTF-8 characters can be represented in ISO-8859-1, so I get 50 warnings and the job aborts. Is there a way to make a best effort conversion and just replace "non-western" characters with blanks?