Solved

mySQL query browser will not display chinese characters properly when inserted from asp script

Posted on 2006-06-09
2
1,321 Views
Last Modified: 2012-06-21
Hi,

I am having a problem with displaying chinese characters in mysql query browser. I have set all possible variables to utf8 and have made the tables utf8 as well. I am currently trying to insert data from an asp script where I have set the encoding in the meta tag to utf-8 as well. I have also put charset = utf8 in the connection string as well. When I insert a record that contains chinese characters (utf8) I get some garbage characters that look like big5 in an english encoding. However when I retrieve the record from the database I will get a record that displays chinese correctly in the script. It just doesn't display correctly in mysql query browser. I can paste chinese (utf8) properly into tables using mysql query browser but in this case when a record is retrieved I get ??? in the web browser when running the script even if I change the encoding to big5 or any other chinese encoding. I have spent a lot of time on this and have yet to find a solution.

Show Variables;

character_set_client utf8
character_set_connection utf8
character_set_database utf8
character_set_filesystem binary
character_set_results utf8
character_set_server utf8
character_set_system utf8

Thanks,
Bluefusion

0
Comment
Question by:Bluefusion
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 29

Accepted Solution

by:
fibo earned 500 total points
ID: 16879908
I have good news and bad news.
First the good: all your stuff works fine, except #@$€!§ display in mysql query browser.
Bad news: maybe it will never dislay properly in the query browser

Good news: so what? who cares? you are currently caring, because you suspect this might clue at something wrong... but what is important is that your script do display correctly the data in your database, which is the important part! Part of your debug process does not work, but your goal is to have the process right, not to debug the debug!

Some hints:
- not sure which program you mean by "mysql query browser", there could be lots of them. (if you have not already, consider also using phpmyadmin)
Assuming however that, like phpmyadmin, they display their results into a browser:
- display your query results as usual (you get the same garbage as usual)
- now change the character code used to display the page. In internet explorer, this should be something like "display" / "codepage" there you'll need to experiment with various options (add/ remove "automatic"; "UTF-8", "simplified Chinese", etc.) [for firefox: "display" / "character codes" ...]. You may find that one of these correctly displays the results.
- If you are not using phpmyadmin, I suggest strongly that you do. The most recent version handles reasonably well this character code problem; previous don't... but the trick I described above works in most cases [note howver that since phpmyadmin uses frames, it is the codes of the rightmost frame that you need to change: do a right-click from above this frame, and change charcetr codes from here]. If your server does not have phpmyadmin already install, you can install it in a directory of your choice, it is a php script you just have to copy at the right place.
The homepage for phpmyadmin is at http://www.phpmyadmin.net/home_page/index.php and you can download files from http://www.phpmyadmin.net/home_page/downloads.php
0
 

Author Comment

by:Bluefusion
ID: 16881970
Thanks for the response.

I guess I'll give phpmyadmin a try.

By mysql query browser I mean the GUI that can be downloaded from the mysql website that handles the editing of tables and their contents.
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

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

Introduction In this installment of my SQL tidbits, I will be looking at parsing Extensible Markup Language (XML) directly passed as string parameters to MySQL 5.1.5 or higher. These would be instances where LOAD_FILE (http://dev.mysql.com/doc/refm…
Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…

738 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