>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