I'm currently using mySQL 4.1.8 with a bug-tracking application- JIRA. (http://www.atlassian.com/software/jira/) In order to display chinese character in JIRA for bug issues, it needs to have UTF8 character set which we already configured in both JIRA and MySQL. However, when I type "mysql --help" in command prompt, it still shows "lantin1" for default-character-set. I'd like to ask how can I change the default-character-set to UTF8? (I already tried the MySQL server Config Wizard)
mysql> show variables like "char%"; character_set_client | latin1 character_set_connection | latin1 character_set_database | utf8 character_set_results | latin1 character_set_server | utf8 character_set_system | utf8 character_set_dir | c:\Program Files\MySQL\MySQL Server 4.1\share\charsets ------------------------------------------------------------------------------------------- c:\> mysql --help default-character-set latin1 How can I change this to: default-character-set <default-character-set> instead of "lantin1" Thank you very much.
