MySQL Bugs: #59637: Connecting to a MySQL view returns ^chinese^ text

Bug #59637	Connecting to a MySQL view returns ^chinese^ text
Submitted:	20 Jan 2011 14:32	Modified:	31 Jan 2011 8:18
Reporter:	Louis Breda van	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	Connector / ODBC	Severity:	S2 (Serious)
Version:	5.1.8	OS:	Windows
Assigned to:		CPU Architecture:	Any
Tags:	ADODB, Chinese, fieldtype, VIEW

Description:
Hello,

When accessing a MySQL view via an ODBC-connection, something goes terrible wrong. Lots of fields seems to contain chinese characters in state of their real data.

When opening the MySQL-view which the MySQL query browser (gui-tools), the data is OK.

When addtional to the data also looking at the datatypes the ODBC-connector is returning towards the client application (in my case MsAccess), that seems to be wrong as well.

This is very annoying since it blocks you form preprocessing / selecting data at the server (MySQL) side.

Sincerely,

Louis 

How to repeat:
1) Create one ore more tables within the MySQL DB. Make sure there are a couple of diffent field types in those tables

2) Create a view related to those tables, containing multiple field types

3) Populate the tables with data

4) Create an ODBC-connction towards e.g. MsAccess

5) Open the table link in the client GUI and be surprised :>

I was using WINDOWS7 64 bit, ODBC5.1.8, INNODB 5.5.8 64 bit server, MsAccess 2010 during the test, but I do not think the problem is restricted to those versions.

Louis, I already notified Lawrin of this report and stated I have more info available.

Louuis, I think this is a duplicate of BUG#58094 and, in ultimately, BUG#55245. Will let Bogdan make final ruling.

Louis,

I think Tonci is right, this bug report indeed looks like the duplicate of bug #58094:

http://bugs.mysql.com/bug.php?id=58094