Forum Moderators: open

Message Too Old, No Replies

Collation column in table properties?

Can not change to UTF8 for enum

         

tomda

10:59 am on Nov 18, 2005 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



Hi,

Got recently the last PHPMYADMIN and noticed the implementation of a new property called "COLLATION".

By default, collation are "latin1_swedish_ci" so I am currently busy changing it to "utf8_unicode_ci".

1st question: Is it really useful to do this?
2nd question: Why does it refuse to change the collation to UTF when it is an enum?

Thanks

physics

5:58 pm on Dec 5, 2005 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



What are some example values of rows in the collation column? If it's something used internally by phpmyadmin maybe it doesn't need to be UTF8?

tomda

8:16 am on Dec 7, 2005 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



Thank you Physics,

No, it is not use internally.
I have change the default collation value to UTF8-Unicode.

Nonetheless, the enum is still "latin1_swedish_ci" and I don't know how to change it.