MySQL Bugs: #12248: Insert using prepared statement fails for latin-1 characters greater than 128

Bug #12248	Insert using prepared statement fails for latin-1 characters greater than 128
Submitted:	28 Jul 2005 19:32	Modified:	10 Aug 2005 18:09
Reporter:	Paul Bonfanti	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	Connector / NET	Severity:	S1 (Critical)
Version:	1.0.4	OS:	Windows (Windows XP)
Assigned to:	Assigned Account	CPU Architecture:	Any

Description:
Insert using prepared statement fails for latin-1 characters greater than 128.  For example, using a prepared statement to insert the string "Eureka! A fórmula" will cause it to be inserted as "Eureka! A f".

How to repeat:
I'll attach a file that can be used to reproduce this problem.

This file shows the problem.

Attachment: Class1.jsl (text/plain), 3.38 KiB.

Note that when I attached the file the string "Eureka! A fórmula" became "Eureka! A f?rmula".  You'll need to change it back in order to reproduce the problem.

Could you please check your character sets according to URL:

http://dev.mysql.com/doc/mysql/en/charset-we-sets.html

When I installed MySQL 4.1.13 on Windows XP, I selected UTF-8 as the character set.  In the my.ini file I see "default-character-set=utf8".  With UTF-8 as the character set, I would expect to be able to insert any unicode character but the example I attached to this bug fails for any characters over 128.

This is the same bug as 12245.  This is fixed in 1.0.5.