I am adding tables to a Wordpress database on my localhost and it is changing my collation from utf8_general_ci to latin1_swedish_ci. I'm kinda stumped because I'm not familiar with working directly with databases since I am new to them. Could you explain why this happens?

My default character set is utf8 and my collation is utf8_general_ci.

Also, when I use the same code to create a table in other databases it works correctly.

HOLY CRAP I just now tried using wordpresses $wpdb class and it is doing the SAME THING! What the crap!

FOUND ANSWER AT WORDPRESS ANSWERS ---- https://wordpress.stackexchange.com/questions/5927/default-table-collation-on-plugin-activation?rq=1

migrated from stackoverflow.com Oct 27 '12 at 8:42

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

  • Off-topic for SO; belongs on Database Administrators – Jim Garrison Oct 27 '12 at 6:02
  • What is the default collation for your database? – Mike Brant Oct 27 '12 at 6:06
  • My default character set is utf8 and my collate is utf8_general_ci. – Robert Ruby II Oct 27 '12 at 16:16
  • This very much so makes no sense at all. I am, using the same exact class I wrote, creating tables in other databases and it is creating them with the correct data. – Robert Ruby II Oct 27 '12 at 16:31
  • If you really found an answer, please, answer your question in a proper answer. You can even accept it afterwards. – dezso Oct 27 '12 at 17:45

Your Answer

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

Browse other questions tagged or ask your own question.