[Codestriker-commits] CVS update: codestriker/doc codestriker.sgml

[<si...@us...>]

  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 codestriker@localhost 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>