MySql Table Collation

Posted in: darrelrussell.com edit

06 Jan 2009

I was having some problems with couple hacks about language. Some turkish chracters were not encoded correct. I searched a lot and figured out that the language collation in some tables were different then the regular tables.

What i did is change collations in each row that needs to be changed and the problem is solved but the main tables collation is still different.

Is there anyway to change the table collation in Mysql ? If so how can i do this ?

To change that, click on Operations in phpMyAdmin.
There should be a dropdown field that allows you to set the collation near the bottom.

To change that, click on Operations in phpMyAdmin.
There should be a dropdown field that allows you to set the collation near the bottom.
Thanks Colin

#If you have any other info about this subject , Please add it free.#

darrelrussell

MySql Table Collation

Author

Archives