I am adding tables to a Wordpress database on my localhost and it is changing my collation from
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
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