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

Hi,

>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?'

Indeed I did the test on Win98 Portuguese version and I got the
behavior for you reported with the difference that both versions
3.23.58 and 4.0.16 showed the same behavior.
However I noticed that directly in the command prompt these
characters also weren't showed correctly and that computer
uses a non-adequate keyboard for the OS version. So I did
a test on my XP machine which has an adequate keyboard and the
character were showed correctly and for to confirm my suspects
I modified the keyboard configuration for another one which
isn't the correct one and in this case I got the same behavior than
Win98.

>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.

I suggest you for to verify if the code page and keyboard are correctly
configured with your OS version.

-- 
Regards,

For technical support contracts, visit https://order.mysql.com/
Are you MySQL certified?, http://www.mysql.com/certification/

Miguel Angel Solórzano <[email protected]>
São Paulo - Brazil


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.547 / Virus Database: 340 - Release Date: 2/12/2003

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