Why does my GUI front end or browser not display CJK characters correctly in my application using Access, PHP, or another API?
Obtain a direct connection to the server using the mysql client (Windows: mysql.exe), and try the same query there. If mysql responds correctly, then the trouble may be that your application interface requires initialization. Use mysql to tell you what character set or sets it uses with the statement SHOW VARIABLES LIKE ‘char%’;. If you are using Access, then you are most likely connecting with MyODBC. In this case, you should check Section 21.1.4, “Connector/ODBC Configuration”. If, for instance, you use big5, you would enter SET NAMES ‘big5’. (Note that no ; is required in this case). If you are using ASP, you might need to add SET NAMES in the code.
Related Questions
- When connecting an LCD panel in my application, the LCD display does not function correctly and appears to flash. What is the reason for this?
- Some screens display the astrology symbols correctly, while other screens display strange looking characters instead. How can I fix this?
- Why does my GUI front end or browser not display CJK characters correctly in my application using Access, PHP, or another API?