PDA

View Full Version : MySql Table Collation


Lizard King
07-05-2006, 09:29 AM
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 ?

Edit : Added a screenshot

Code Monkey
07-05-2006, 01:21 PM
Click on the structure icon for that table (second from left) and then click on operations link up top. It's a drop down selection in there.