Hi Gleb,
Ok here is the command line info which also answers the version question.
Enter password: **********
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 4.1.9-nt
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> show variables like '%char%';
+--------------------------+--------------------+
| Variable_name | Value |
+--------------------------+--------------------+
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | utf8 |
| character_set_results | latin1 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | C:\share\charsets/ |
+--------------------------+--------------------+
7 rows in set (0.72 sec)
mysql>
I am downloading v.10 right now. I believed we were using .10 but in
verifying I have found not. I will re-test when the upgrade is installed.
Many thanks
Rob
Gleb Paharenko wrote:
>
> At first, we should check that there is nothing wrong with the
> character_set_xxx variables. Please send us the output of the
> following statement:
>
> show variables like '%char%';
>
> Does the problem remain if you are making the query using a mysql
> command line client? Do you use the latest release (4.1.10 now)?
>
>
>
