CodeIgniter using MySQL

[eluser]InsiteFX[/eluser]
@toopay
I said that because no one here mentioned the InnoDB.

MySQL defaults to the InnoDB database now when you create a new database.

But you should still specify the Engine=InnoDB for the type.

Just like a lot of users create their database and then wonder why utf8 and utf8_general_ci doe's not work!

And the answer is because when you create a new database MySQL sets the collation to a default of latin1_swedish_ci !

With phpMyAdmin you have to click on the new database before entering any records and then click on the Operations tab, then if you look at the bottom of the page you will see the collation is set to latin1_swedish_ci. To change enter a new one either utf8_general_ci or utf8_unicode_ci click GO!

If the database is already containing records then you need to make a SQL dump change the collation and the use the dump to put them back or they will get corrupted.

InsiteFX