Hi all, I have compiled mysqld 5.0.37 with utf support: ( configure --with-charset=utf8 --with-extra-charsets=none)
utf8 is the default in my.cnf: ( [mysqld] character-set-server=utf8 and [mysql] default-character-set=utf8 ) mysqld acknowledges it: mysql> show variables like "charac%"; +--------------------------+-----------------------------------------+ | Variable_name | Value | +--------------------------+-----------------------------------------+ | character_set_client | utf8 | | character_set_connection | utf8 | | character_set_database | utf8 | | character_set_filesystem | binary | | character_set_results | utf8 | | character_set_server | utf8 | | character_set_system | utf8 | | character_sets_dir | /opt/servers/mysql/data/mysql/charsets/ | +--------------------------+-----------------------------------------+ and my databases/tables are created with "DEFAULT CHARSET=utf8" Shouldn't everything be OK? well, SELECTs display foreign chars ok, and batch inserts with mysql<insert-cmds-file work ok BUT when I try to add a foreign text from the keyboard in the mysql client, keystrokes are ignored! unless they are numbers, commas etc (using kde-konsole with the the DeJaVu international font) I believe this has to do something with the compilation and not configuration; because if I use the mysql-client rpm packages from SUSE 10.2, the keyboard works ok in interactive mysql sessions! Any ideas will be very much appreciated!