Re: Problem inserting german and french characters
Posted by: Alexander Barkov
Date: March 16, 2008 10:47AM

MySQL client character set settings do not match
the actual character set of the inserted data.

Try this:

show variables like 'character_set%';
select hex('ß');

The correct variants:

1. Everything is utf8:

character_set_client=utf8
hex('ß') = C39F

2. Everything is latin1:

character_Set_client=latin1
hex('ß') = DF

3. Everything is cp850 (in Windows console)

character_Set_client=cp850
hex('ß') = E1


Most likely you'll get a mixture:
character_set_client doesn't match correct HEX result.

If so, then before doing INSERTs/SELECTs/UPDATEs
try to run "SET NAMES xxx" query, where xxx
is character set matching one of the above HEX
representation for ß.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Problem inserting german and french characters
5793
March 16, 2008 10:47AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.