Bug #2357 control center replaces unicode (Hindi) characters by ?
Submitted: 12 Jan 2004 9:25 Modified: 1 Jun 2004 0:34
Reporter: [ name withheld ] Email Updates:
Status: Closed Impact on me:
None 
Category:MySQLCC Severity:S3 (Non-critical)
Version:0.9.4 OS:Windows (ms windows xp)
Assigned to: Jorge del Conde CPU Architecture:Any

[12 Jan 2004 9:25] [ name withheld ] 
Description:
||Shriharih||

I am able to type Indic (Hindi unicode only) characters in control center 0.9.4 by changing to a Unicode application font under options and using the language bar in Win XP using Mysql 4.1 alpha. The characters display correctly when I enter some data in a table (characterset utf8). But the moemnt, I press enter the insert SQL that is fired replaces these characters by "?"s (question marks).

Possibly it's not yet configured to take unicode entry.

How to repeat:
||Shriharih||

Alter a database and table to characterset utf8, add a unicode only language like Hindi to the language bar from regional settings in Win XP control panel and after selecting that keyboard, type into that table's data entry screen in control center. Hit enter, and the query will replace unicode characters by ? and only ?'s will be retrieved later also. (you may need to set application font to a unicode font too to display correctly).
[22 Mar 2004 3:46] bachtiar zumba 
My problem is probably the same. I use utf8 character set on a database, and I can type latin2 characters in varchar column. However, when I refresh the query, two letters are converted:

Unicode 0x010d (ccaron) -> c
Unicode 0x010c (Ccaron) -> C

However, some other latin2 characters work ok, namely 0x161, 0x17e, 0x160, 0x17d.

By the way, how can I specifiy connection character set in Control Center? Do I need to specify? How does Control Center determine which characters it should send to the server?

Thank you.
[1 Jun 2004 0:34] Jorge del Conde 
Hi!

MySQLCC has been discontinued and will not be developed nor maintained anymore with the exception of Critical bugs.

In the near future we will release the substitute of MySQLCC called MySQL Query Browser.