Solved

Display Chinese characters in MS Access with MySQL database

Posted on 2008-10-25
11
811 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
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

 
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

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.

Question has a verified solution.

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

Suggested Solutions

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
When table data gets too large to manage or queries take too long to execute the solution is often to buy bigger hardware or assign more CPUs and memory resources to the machine to solve the problem. However, the best, cheapest and most effective so…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

820 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