From ad56004cd69afbbbbd7eff3ec630256b2d098132 Mon Sep 17 00:00:00 2001 From: alecpl Date: Mon, 16 Feb 2009 09:54:53 +0000 Subject: - added info to create unicode database (#1485687) --- INSTALL | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'INSTALL') diff --git a/INSTALL b/INSTALL index 8d57eb2a1..5f2f3dd60 100644 --- a/INSTALL +++ b/INSTALL @@ -53,7 +53,7 @@ importing the table layout and granting the proper permissions to the roundcube user. Here is an example of that procedure: # mysql -> CREATE DATABASE roundcubemail; +> CREATE DATABASE roundcubemail /*!40101 CHARACTER SET utf8 COLLATE utf8_general_ci */; > GRANT ALL PRIVILEGES ON roundcubemail.* TO roundcube@localhost IDENTIFIED BY 'password'; > quit @@ -88,7 +88,7 @@ simple steps, which have to be done as the postgres system user (or which ever is the database superuser): $ createuser roundcube -$ createdb -O roundcube roundcubemail +$ createdb -O roundcube -E UNICODE roundcubemail $ psql roundcubemail roundcubemail =# ALTER USER roundcube WITH PASSWORD 'the_new_password'; -- cgit v1.2.3