Re: Cannot create database in MySQL

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'd like to check why mysql
> complains about the syntax (which apparently works ok in versions
> 4.1 through 5.0).

I must correct myself.  First, I mixed up the MySQL version on two
of my machines.  The server runs with 5.0.51a.

Secondly, the name "references" is bad for the database because it
seems to be a reserved word or something like that (unfortunately,
at the same time it's a good name for a references DB ;-).  With
"biblio", it worked.

However, I run into trouble here and there because "deb
http://refdb.sourceforge.net/debian/svn testing main" gives me an
outdated version (from March 2007 or so).  Is it feasible to update
this?  If not, I'm highly probably able to install the SVN version.
:)

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