mySQL query browser will not display chinese characters properly when inserted from asp script
Posted on 2006-06-09
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.