Re: Cannot create database in MySQL

Torsten Bronger <[email protected]> Fri, 30 Jan 2009 22:54:40 +0100
Newsgroups gmane.text.refdb.general
Organization Phoenix Foundation
Message-ID <[email protected]>
Hallöchen!

Markus Hoenicka writes:

> Torsten Bronger writes:
>
>>     CREATE DATABASE references CHARACTER SET 'utf8'
>> 1064: You have an error in your SQL syntax; check the manual that
>> corresponds to your MySQL server version for the right syntax to
>> use near references CHARACTER SET 'utf8'' at line 1
>
> Which mysql version are you using?

I use MySQL 5.0.67.  What I changed from the default configuration
is:

default-storage_engine = innodb
character-set-server=utf8
collation-server=utf8_unicode_ci
init_connect='set collation_connection = utf8_unicode_ci;'

Tschö,
Torsten.

-- 
Torsten Bronger, aquisgrana, europa vetus
                   Jabber ID: [email protected]

------------------------------------------------------------------------------
This SF.net email is sponsored by:
SourcForge Community
SourceForge wants to tell your story.
http://p.sf.net/sfu/sf-spreadtheword