MYSQL database collation - question

mhtcka / 2012-09-26 10:57:08   

problem:
In order to be able to write greek in my cms, i need to change the collation of my database (all tables, all fields inside phpmyadmin) from 'latin-swedish-ci' >>to>> 'utf8-general-ci'...It is a manual process that takes about 20-30 minutes...

question:
I was wondering if there is an automatic way through phpmyadmin, perhaps using an sql query to change the collation...

p.s.
why 'latin-swedish-ci' ?

Vaska A / 2012-09-26 11:13:19   

By default Indexhibit tries to install as utf8-unicode-ci but some mysql setups do not allow us to set that - you get their default. This pertains to older versions of mysql, I believe.

This thread has been closed, thank you.