MySQL 4.015/4.016 (Win & Linux): converts special characters to '?' with INSERT and UPDATE

Dear MySQL team,

I am experiencing the following bug in MySQL 4.015 and 4.016 under Win98SE.

MySQL converts special characters like n-dash (if you hold down ALT and
press 0150 on num keys) or typographic quotes (ALT+0132, ALT+0147) to
question marks ('?').

Example: INSERT INTO test SET column = '\„Hello there\“'	-> '?Hello there?'

It occurss with MyISAM and innoDB tables. It's got nothing to do with
escaping quotes or whatever - it must be something else.

Inserting or updating those characters worked without problems in MySQL 3.23
but doesn't work anymore in MySQL 4. Strangely those characters are inserted
via LOAD DATA INFILE but not with INSERT or UPDATE.

I coudln't find anything on the MySQL website about it and no one on the
MySQL mailing list is answering my emails regarding this. Please send a
short feedback if this is a bug or I need to enable a special option.

Thanks in advance!


Best regards,

Torsten Roehr


-- 
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe:    http://lists.mysql.com/[email protected]