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

--=======31CE4547=======
Content-Type: text/plain; x-avg-checked=avg-ok-1B7336; charset=iso-8859-1; format=flowed
Content-Transfer-Encoding: quoted-printable

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 =3D '\?Hello there\?' ->=
'?Hello=20
>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.

--=20
Regards,

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

Miguel Angel Sol=F3rzano
S=E3o Paulo - Brazil

--=======31CE4547=======
Content-Type: text/plain; charset=us-ascii; x-avg=cert; x-avg-checked=avg-ok-1B7336
Content-Disposition: inline


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


--=======31CE4547=======
Content-Type: text/plain; charset=us-ascii

--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs@m.gmane.org
--=======31CE4547=======--