Mysql-based Crystal Reports and garbled Solutions

Basic MySQL parameter settings

Create a database with the UTF-8 character set

 
Two tables are created. The test1 character set is gb2312 and test2utf8 is UTF-8.
 

The data in the table is in Chinese.

Follow these steps to create a report using MySQL:
 

The driver string we use is:

Driver = {MySQL ODBC 3.51 driver}; server = localhost; database = test; user = root; Password = root; option = 3;

 

The report generated at this time is like this,

 

In the program, the effect is as follows:

 

Solution:

Install MySQL 5.1 Driver

Http://dev.mysql.com/downloads/connector/odbc/5.1.html

The driver connection string is:

Driver = {MySQL ODBC 5.1 Driver}; server = localhost; database = test; user = root; Password = root; option = 3;

 

Report effect:

Program display effect:
 

Reference: http://www.connectionstrings.com/default.aspx? Carrier = MySQL
An additional article that may be useful:
MySQL garbled characters are successfully solved! Http://faq.csdn.net/read/216877.html

-- Over --