Re: Problems with character

[Stefano Moncelli]

I have installed mysql-5.0.19 on Windows and I have repeated the test.
I use EMS MySQL Manager as client.

I tried with EMS:

insert into test values('cliché');
select name,char_length(name),length(name) from t1;
+--------+-------------------+--------------+
| name | char_length(name) | length(name) |
+--------+-------------------+--------------+
| cliché | 6 | 7 |
+--------+-------------------+--------------+

but from 'mysql' command line client:

select name,char_length(name),length(name) from t1;
+--------+-------------------+--------------+
| name | char_length(name) | length(name) |
+--------+-------------------+--------------+
| clichÚ | 6 | 7 |
+--------+-------------------+--------------+

On the other side, if I try to insert from 'mysql' command line client
and read from EMS I obtain:
+--------+-------------------+--------------+
| name | char_length(name) | length(name) |
+--------+-------------------+--------------+
| clich‚ | 6 | 8 |
+--------+-------------------+--------------+

Do you kwnow why this happens?

Regards,

-- Stefano