Stanley Suen wrote:
> However, if I use Unicode 主 for
> example, the Chinese characters are then displayed
> on the web site properly. As you know, entering
> chinese characters in unicode is a pain in the
> neck.
Unicode is the best way to go as it prevents trouble with non-chinese systems and is generally more flexible. However I'd strongly recommend to use a proper tool for such work like our MySQL Query Browser (http://dev.mysql.com/downloads/query-browser/1.1.html). It works with Unicode and allows to enter data in any language. It even supports IMEs on Windows to help writing text in languages for which no keyboard is available. Addtionally, QB is much quicker and easier to use than phpMyAdmin and does not require a running webserver. You can use it with remote databases of course, either by connecting via port 3306 (if firewall allows) or via an SSH tunnel. I can give details if you need them.
Mike
Mike Lischke, MySQL Developer Tools
Oracle Corporation
MySQL Workbench on Github:
https://github.com/mysql/mysql-workbench
On Twitter:
https://twitter.com/MySQLWorkbench
On Slack: mysqlcommunity.slack.com (#workbench)
Report bugs to
http://bugs.mysql.com
MySQL documentation can be found here:
http://dev.mysql.com/doc/refman/8.0/en/