Solved

Display Chinese characters in MS Access with MySQL database

Posted on 2008-10-25
11
807 Views
Last Modified: 2012-06-21
I have same problem as I see many others have, using a MS Access front end linking to  MySQL database using ODBC connector 3.51, Chinese Characters are displayed as ??????.
Numerous searches have not provided any answer of how to resolve this.

Is there a solution out available?

Many thanks
0
Comment
Question by:richardhubbard
  • 3
  • 3
11 Comments
 
LVL 46

Expert Comment

by:tbsgadi
ID: 22806398
0
 
LVL 1

Author Comment

by:richardhubbard
ID: 22808117
Thanks for the pointer. It was helpful but has not given me a solution
I have been able to add a chinese character to a MySQL table, and it displays correctly when doing a query through the MySQL Query Browser.
But when viewed in Access it is back to the ?
I have been able to add Chinese characters in the table within access and moving between records, they have continued to be displayed.
But if I close and open the table, they go to ????

I guess what I am really looking for is directions of how to set up MySQL and MS Access linking to MySQL via ODBC connector to display Chinese characters.

I can enter Chinese characters to a table based on Access.
As per above I can added Chinese Characters to a MySQL table

But it is getting the two working together is the challenge.

If anyone has done this could they post the actual settings required to achieve this result.
I will be entering simplified Chinese characters gb2312 rather than big5
0
 
LVL 27

Accepted Solution

by:
jjafferr earned 500 total points
ID: 22911734
Hi

I read sometime ago, somewhere, that a new mySQL ODBC solves this issue.

jaffer
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 1

Author Comment

by:richardhubbard
ID: 22982589
Greetings

Thanks for the pointer, just installed 5.1 ODBC, but does not solve issue immediately.

If this is the solution there will be other settings I need to get sorted, such as column type and character type settings.

I am trusting someone else has gone through the process and is able to share their results.
I will continue to try and post results if successful.
0
 
LVL 27

Expert Comment

by:jjafferr
ID: 23163209
richard

please have a look at this mySQL site link:
http://bugs.mysql.com/bug.php?id=18731

it deals with your problem, with some solutions.

and here are yet other links:
http://imysql.cn/docs/MySQL_51_en/ch10s10.html
http://www.dbforums.com/showthread.php?t=1627060

If none of the above links help, please check the FAQ of mySQL, or place a bug report on their site, as they are the developers of that software, so they "should" have an answer.

jaffer
0
 
LVL 1

Author Closing Comment

by:richardhubbard
ID: 31526021
When I first updated the driver it made no difference. And did not try again for some time.
But as final try before closing question I tried again and it was fine. May be computer needed a reboot or something else. Difficult to tell given the time that has passed.
Final comment - to get the characters to display I used
InnoDb engine
varchar(50) but this may not be essential, may be able to reduce the size
Set Column Charset utf8. I found unicode and bin options worked.
Thanks for your continued help to set this resolved

For info the links to the other website while sort of interesting had a lot of technical information much of which was not relevant.
0
 
LVL 27

Expert Comment

by:jjafferr
ID: 23173965
well, I am glad it is working for you,
thanks for the points and the grade.

As time passes, it is getting closer and closer for me to use mySQL too, and with your tip, I hope the ride will be smooooooth :)

jaffer
0

Featured Post

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
Introduction Since I wrote the original article about Handling Date and Time in PHP and MySQL (http://www.experts-exchange.com/articles/201/Handling-Date-and-Time-in-PHP-and-MySQL.html) several years ago, it seemed like now was a good time to updat…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question