From ad56004cd69afbbbbd7eff3ec630256b2d098132 Mon Sep 17 00:00:00 2001
From: alecpl <alec@alec.pl>
Date: Mon, 16 Feb 2009 04:54:53 -0500
Subject: [PATCH] - added info to create unicode database (#1485687)
---
INSTALL | 4 ++--
1 files changed, 2 insertions(+), 2 deletions(-)
diff --git a/INSTALL b/INSTALL
index 8d57eb2..5f2f3dd 100644
--- a/INSTALL
+++ b/INSTALL
@@ -53,7 +53,7 @@
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 @@
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';
--
Gitblit v1.9.1