how to change mysql database encoding from latin to utf8

Tapas Mishra mightydreams at gmail.com
Thu Feb 17 11:25:39 UTC 2011


I checked
mysql> create database sakai;
Query OK, 1 row affected (0.00 sec)

mysql> show create database sakai;
+----------+------------------------------------------------------------------+
| Database | Create Database                                                  |
+----------+------------------------------------------------------------------+
| sakai    | CREATE DATABASE `sakai` /*!40100 DEFAULT CHARACTER SET latin1 */ |
+----------+------------------------------------------------------------------+
1 row in set (0.00 sec)

Now section 7.0 of following page
https://confluence.sakaiproject.org/display/DOC/Sakai+2.7
says I should be having
CHARACTER SET utf8 */ |

for mysql on sakai to run.
So how to achieve it.
This is mysql 5.1+ on lucid 64 bit.




More information about the ubuntu-server mailing list