From: Martijn Tonies
Date: August 15 2005 8:43am
Subject: Re: cannot drop database
List-Archive: http://lists.mysql.com/mysql/187816
Message-Id: <011901c5a175$71164e60$3802a8c0@martijnws>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 8bit



> I need to drop a database named  รรกรฃรรกร using the mysql client.  I'm
> getting "you have an error in your sql syntax" for the command
>
> DROP database รรกรฃรรกร;
>
> I'm sure this is a character set issue.  How can I drop this database?

What about using backticks around it:

drop database `yourname`

With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com