Bug #16660 Crystal Report 9.0 can't show Chinese words with MySQL Server 4.1.15(utf8)

• Submitted: 20 Jan 2006 2:43
• Modified: 20 Jan 2006 9:14
• Reporter: Laura Chen
• Status: Not a Bug
• Category: MySQL Server
• Severity: S3 (Non-critical)
• CPU Architecture: Any

[20 Jan 2006 2:43] Laura Chen

Description:
I use MySQL Server 4.1.15 and can see or insert Chinese words with MySQL Query Browser.I also can insert or show Chinese words through a JAVA-based web portal.But all Chinese words became question marks such as ? when I tried to show MySQL data with Crystal Report.Did someone meet the same problem before and can give me some suggrstion?Deeply appreciate your suggestion or possible solution.

environment as follows:

Windows2000
MySQL Server 4.1.15
MySQL ODBC 3.51 Driver(3.51.12.00)
MySQL Administrator 1.0.20(Charset:utf8 Collation:utf8_general_ci)
MySQL Query Browser 1.1.10
Crystal Report 9.0
JAVA WEB Interface using JSpeed(Charset:utf8)

How to repeat:
1.Using MySQL Server 4.1.15 and MySQL Administrator 1.0.20(Charset:utf8 Collation:utf8_general_ci) to create a testing table with a varchar column.
2.Using MySQL Query Browser 1.1.10 and Keying Chinese words.
3.Using Crystal Report 9.0,connecting to the data source you created and see if the Chinese words can show correctly.

[20 Jan 2006 9:14] Aleksey Kishkin

Sorry, we do not maintain crystal report. If you can use Chinese in the QB and java programs it means mysql server and connectors works properly. Could you consider ask 'crystal report' maintainers?

[28 Mar 2006 2:04] jerry wang

i found this problem also. it's not only in crystal report but also in vb input box when you start to read from mysql via connector. English and number is no problem except chinese.