From: Martijn Tonies
Date: February 28 2006 6:19pm
Subject: Re: Some general questions
List-Archive: http://lists.mysql.com/mysql/195268
Message-Id: <004101c63c93$799f9b40$cd02a8c0@martijnws>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit




> I was asked to scope out the following features, and am not the person to
be
> implementing them.
> Hence the manuals weren't particularly helpful.
> I'm looking for definitive references one way or the other for the
following
> questions.
> SOS!
>
> Does MySQL support the following:
> - Support for DDL commands and dynamic SQL inside stored procedures?

Yes.

> - EXECUTE STATEMENT in Stored Procedures. (may be same question as above)

See above.

> - Support for creation of databases inside stored procedures.

I don't know, but it should be easy to try :)

> - Support for UTF-8 data storage in VARCHAR columns.

Yes.

> - Support of CLOBS or TEXT columns such that we can store up to 60,000
bytes
> of TEXT data

Yes.

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