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