how to change mysql database encoding from latin to utf8

2011-02-17 Thread Tapas Mishra 
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.

-- 
ubuntu-server mailing list
ubuntu-server@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-server
More info: https://wiki.ubuntu.com/ServerTeam

Re: how to change mysql database encoding from latin to utf8

2011-02-17 Thread Norbert Tretkowski 
Am Donnerstag, den 17.02.2011, 16:55 +0530 schrieb Tapas Mishra:
 So how to achieve it.

It's all documented in the MySQL Reference Manual:

http://dev.mysql.com/doc/refman/5.1/en/charset.html


Regards

Norbert


-- 
ubuntu-server mailing list
ubuntu-server@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-server
More info: https://wiki.ubuntu.com/ServerTeam