/>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
>
>
Attachment: [text/html]
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.375 / Virus Database: 268.1.0/269 - Release Date: 2/24/2006
