I'm thinking of migrating my database (oracle) from windows-1252 to UTF-8 by doing the following:
- export all data (backup)
- truncate all tables
alter database character set
- import data back
Is there a way to detect if any characters will be lost or need manual adjustments before the migration?
- If so, how?
- If not, then how to prevent losing characters during the migration?