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
  • run 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?

migrated from stackoverflow.com Aug 14 at 13:48

This question came from our site for professional and enthusiast programmers.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy