When exporting the database "don't" changes to "Don’t" and other words gets messed up, the database is using UTF-8 General and i am exporting through phpmyadmin, a complete uncompressed export with all default settings, i am trying another export with "Disable foreign key checks" selected. Does anyone have any suggestions on whats going wrong?
Figure out what char set the database tables are in. Verify on a table level that they are in UTF-8. The database can be set to UTF-8 by default while individual tables are set to latin1 or something else.
I see... so although the main datbase is saying UTF-8 the tables are actually saying latin1_swedish_ci so what do i need to do to export them without the data messing up, do i change the tables to UTF-8? or something else?
I have changed all my tables from latin1_swedish_ci to utf-8_unicode_ci done a fresh export and its still getting all messed up, need some more suggestions.