Submit Your Article Forum Rules

Results 1 to 1 of 1

Thread: Solved: Exporting MySQL with charset as UTF-8 corrupting characters/data?

  1. #1
    Member MyRentals's Avatar
    Join Date
    Jul 2012
    Location
    USA
    Posts
    33

    Lightbulb Solved: Exporting MySQL with charset as UTF-8 corrupting characters/data?

    I saw the following thread:
    (http://www.webproworld.com/webmaster...ort-amp-Import) "phpMyAdmin - Export & Import" when looking to solve "UTF-8 export data corruption using the MyAdmin php Console" and was going to add my description of how I solved it, which turned out to be very easy. (The webproworld forum suggested I open a new thread due to age, so I have)

    It ALL has to do with the MySQL connection collation setting on the localhost Index page:
    Attachment 691
    SEE ATTACHMENT ABOVE |
    As you can see from the orange highlighted area in the image attachment. It was set at UTF-8, but my data was being saved from the application using latin1_swedish_ci. So I changed both the MyAdmin collation settings of the exporting MySQL server and the new receiving MySQL server collation settings to the latin1 setting BEFORE exporting the database.

    The data is exported without corruption.
    The new database is imported with the sql file and the data is as it should be.

    [no more weirdness with strange characters like £ instead of purely a £ character etc. ]
    Last edited by MyRentals; 07-22-2012 at 09:41 PM.

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
  •