Re: charset problem

[László Kővári]

I found a possible solution for this problem.
The following settings need to put into my.ini
[mysqld]
init_connect='SET collation_connection = utf8_hungarian_ci'
init_connect='SET NAMES utf8'
character-set-filesystem=utf8
character-set-server=utf8
collation-server=utf8_hungarian_ci
skip-character-set-client-handshake
After need to modify the collation of database:
ALTER DATABASE dict CHARACTER SET utf8 COLLATE utf8_hungarian_ci;
All content is need to exists in the selected character set,therefore I needed to convert it to desired character set, in this case utf8_hungarian_ci
ALTER TABLE words CONVERT TO CHARACTER SET utf8 COLLATE utf8_hungarian_ci;
Of course not need the BINARY option after WHERE keyword.