1

I have a database in which I store the alt and title values of the images. Unfortunately the program which inserts these values hasn't been connecting to the MySQL database with a UTF-8 link and the data it has inserted to the database is not in Unicode. I have fixed that but I was wondering if there is some way to retrieve the original values from the database and convert them to Unicod

0

1 Answer 1

1

A possible solution:

  1. Dump your table data with mysqldump or any other favorite tool
  2. Fix encoding in dump file using one of the utilities (there are plenty out there)
  3. Load data back

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.