User: sits
Date: 06/05/31 00:02:19
Modified: doc codestriker.sgml
Log:
Added doco for creating utf8 databases for MySQL and PostgreSQL. SQL Server
works as is. Oracle is still an unknown.
Index: codestriker.sgml
===================================================================
RCS file: /cvsroot/codestriker/codestriker/doc/codestriker.sgml,v
retrieving revision 1.52
retrieving revision 1.53
diff -u -r1.52 -r1.53
--- codestriker.sgml 18 Apr 2006 10:45:40 -0000 1.52
+++ codestriker.sgml 31 May 2006 07:02:19 -0000 1.53
@@ -161,6 +161,8 @@
available for download from
<ulink
url="http://www.mysql.com";>http://www.mysql.com</ulink>.
+ Make sure you use at least version 4.1 or above, as this
+ supports UTF8 databases.
For Linux RedHat distributions, the necessary packages
required are mysql, mysql-devel, mysql-server, which may or
may not already be present on your system. Depending on
@@ -187,7 +189,7 @@
substitute a suitable database password instead of cspasswd
as shown here.
<programlisting>
-CREATE DATABASE codestrikerdb;
+CREATE DATABASE codestrikerdb CHARACTER SET utf8;
GRANT SELECT,INSERT,UPDATE,DELETE,INDEX,ALTER,CREATE,DROP,REFERENCES
ON codestrikerdb.* TO [EMAIL PROTECTED] IDENTIFIED BY 'cspasswd';
@@ -238,7 +240,7 @@
following commands:
<programlisting>
% createuser --username=postgres -d -A codestriker
-% createdb --username=codestriker codestrikerdb
+% createdb -E UTF8 --username=codestriker codestrikerdb
</programlisting>
</para>
<para>
_______________________________________________
Codestriker-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/codestriker-commits
