We have a 3rd party application that recently was updated to allow for WE8MSWIN1252 in place of US7ASCII. The issue is that this database syncs data between other DBs that are AL32UTF8 and SaaS applications. I have tried to explain that this is going to still lead to data issues since WE8MSWIN1252 can't store Unicode characters.
Is there a way to generate a listing of multi byte characters that would not be able to be stored in WE8MSWIN1252? Or would it be possible to generate a listing of any languages that would be impacted by this? In addition to languages, I would expect that a number of "special" characters that could be used in descriptions could be impacted - 3rd, ¼, smart quotes, etc.
Also, for the tables and columns that are common between these DBs, I was wanting to find existing data that would be impacted. I was hoping to find an efficient query to do this. This would allow me to share it with other customers to see how their data would be impacted and then influence the vendor to update their application for Unicode. I thought that I could use the Database Migration Utility (DMU) to see if it could generate a listing of multi byte characters that would be impacted as if I were downgrading from AL32UTF8 to WE8MSWIN1252.
Thanks in advance for any suggestions that you might have.
Brian