I'm currently using MySQL 4.1.18 and phpMyAdmin 126.96.36.199, but I'm having troubles with the character sets...
I'm currenly using UTF-8 Unicode (utf8) with connection collation utf8_general_ci on database, tabel and column level. Everything goes fine when inserting text using a text field in a script, but when I insert a row using phpMyAdmin things go wrong with the euro character. In phpMyAdmin it is displayed correctly, but it isn't on my website... Does anybody knows what the problem could be?
Would it be better to use a different character set for Belgium? Latin1? But with wich collation set latin1_bin, latin1_general_cs, latin1_general_ci,...?