Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2012
    Posts
    25

    Question Unanswered: How to detect corrupted data in db2

    I had some data in UTF8 and converted the data over the time into 8859-1 format and saved in DB2 DB.
    Now I realized that some of the characters are not converted correctly.
    How can I find the rows with corrupted data?

  2. #2
    Join Date
    Oct 2009
    Location
    221B Baker St.
    Posts
    486
    First you would need to define "good" from "corrupted".

    Is this a one-time exercise? If it is, you might consider unloading the problem tables, correcting the data, and reloading the corrected values.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •