Hello Murat,
our database uses utf8 encoding now (and collation sequence utf8_general_ci),
as it should have been all the time.
Tests with Indonesian and Cyrillic chars worked ok.
Thank you for pointing this out,
Heiner
P.S.: MySQL >= 5.0 makes it quite easy to transform character data:
| ALTER TABLE mytable CONVERT TO CHARACTER SET utf8; |
does it.
For all tables in a DB I did (in a bash on linux):
| mysql -B -s -e "show tables" myDB | \ |
| awk '{printf "ALTER TABLE %s CONVERT TO CHARACTER SET utf8;\n",$1}' | \ |
| mysql -B -s myDB |
we use
character-set-server=utf8
collation-server=utf8_general_ci
in /etc/my.cnf, in section mysqld
