Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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 ---- http://wordpress.stackexchange.com/questions/5927/default-table-collation-on-plugin-activation?rq=1

share|improve this question

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
show 2 more comments

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.