Re: Some general questions

[Peter Brawley]

>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

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


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]