Hello.
Put the following line in [mysql] section of your config file: default_character_set=utf8 >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. >>>>"Kitty" <[EMAIL PROTECTED]> wrote: -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]