MySQL Bugs: #13692: Spurious characters when UK Pound symbol is in the data of type VARCHAR

Bug #13692	Spurious characters when UK Pound symbol is in the data of type VARCHAR
Submitted:	2 Oct 2005 17:07	Modified:	4 Oct 2005 7:23
Reporter:	Richard de Courtney	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	Connector / ODBC	Severity:	S3 (Non-critical)
Version:	5.0.13	OS:	Windows (Windows 2003)
Assigned to:		CPU Architecture:	Any

Description:
When storing the GBP Pound Symbol in a UTF-8 character set MyISAM table. The symbol is stored correctly (when viewed through Navicat for example), but when retreiving the data via ASP, the pound symbol is proceeded by a Â symbol. This error only occured during an upgrade from 4.1.14 to 5.0.13 and did not occur in the 4.1.x versions.

See: http://www.wirelessmedia.com/account/store/index-list_category-2000_desc-Premium+SMS+Servi...  for an example (the error is in the Title part of the product descriptions, the costs to the right are hard coded and the pound symbol is not stored in the table for those columns)

How to repeat:
Insert GBP Pound symbol into a VARCHAR columntype

How do your ASP interacts with MySQL? Using ODBC? I believe so, that is why I changed a category. Correct me, if I am wrong.

What version of MyODBC driver do you use? The content of your my.ini file would be useful too.

Please close this bug, it looks as though it was an issue with a change in character sets between the mysql upgrade and navicat (I have enabled UTF-8 in the connection properties of Navicat and it now shows the Â symbol preceeding the Pound sign). Still unsure of whether the upgrade caused the error, or whether it was a data transfer issue, and therefore cannot repeat the bug.

Thanks.

Request of user.