Q: MySQL 4 utf8 charset support.

A: For MySQL 4.1 or later, if you want UTF-8 support, you must create the bugzero database use 
   the utf8 charset or must alter the database before any bugzero tables were created there. 
   Below is the command:

   mysql> CREATE DATABASE bugzero_db CHARACTER SET utf8;

   or, if you create the database without the character set, you can alter it bt

   mysql> ALTER DATABASE bugzero_db CHARACTER SET utf-8;

   After alter your database charset, you will need remove all the tables and re-create them 
   (probably a MySQL bug). 
  
   Of course, if you are using utf8 as the default charset for your mysql server already, then
   you do not need so anything to the bugzero_db database. Also note that, this is only for 
   MySQL 4.1 or later.








* Reference brought to you by 

Bugzero, it's more than just bug tracking software!



Home -
FAQs