>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)
Yes to a limited extent: PREPARE | EXECUTE accepts CREATE TABLE, DELETE, DO, INSERT, REPLACE, SELECT, SET, UPDATE and most database info (SHOW) commands.
>- Support for creation of databases inside stored procedures.
Yes
>- 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.

PB
http://www.artfulsoftware.com

-----

J A wrote:
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?
- EXECUTE STATEMENT in Stored Procedures. (may be same question as above)
- Support for creation of databases inside stored procedures.
- Support for UTF-8 data storage in VARCHAR columns.
- Support of CLOBS or TEXT columns such that we can store up to 60,000 bytes of TEXT data

_________________________________________________________________
On the road to retirement? Check out MSN Life Events for advice on how to get there! http://lifeevents.msn.com/category.aspx?cid=Retirement