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.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

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.