MySQL Bugs: #6349: UTF characters are not displayed (retrieved?) correctly

Bug #6349	UTF characters are not displayed (retrieved?) correctly
Submitted:	31 Oct 2004 16:55	Modified:	3 Nov 2004 13:59
Reporter:	Simon Porritt	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Query Browser	Severity:	S2 (Serious)
Version:	1.0.8 beta	OS:	Windows (Windows 2000)
Assigned to:		CPU Architecture:	Any

Description:
The data table in query browser is displaying Cyrillic text as a succession of question marks.  The data is retrieved from a UTF-8 database that I am able to work with from Java (ConnectorJ 3.0.15) without any encoding problems.  I can INSERT Cyrillic text using the query pane of the query browser, and then retrieve it from a Java app without a problem.  It's just the data table I'm having a problem with.

At least one other person seems to be experiencing this issue:

http://forums.mysql.com/read.php?11,2450,4835#msg-4835

How to repeat:
1. Create a database and specify utf8 as the character encoding.  x
2. Create a table
3. INSERT some text that uses characters not defined by the code page of your default locale (however you like, it doesn't have to be through the query browser)
4. SELECT that data back.  I get - for Cyrillic input on a box whose default locale is the UK - a whole load of question marks.

Suggested fix:
There seems to be an encoding issue with the driver that the query browser is using.  But it's odd because INSERT works and SELECT doesn't.

You have to verify that the character set of you default database is in the correct charset. It isn't enought that a table has the correct encoding at the moment.

This is a bug in the server which will be fixed in one of the next releases. Then, the server will correctly convert the utf8 characters we sent to the appropriate collation.