>Thanks!
>With regard to the ClOBs or Text fields, is that CLOB support?
>Or support for Text columns that hold up to 60,000 bytes of TEXT data?

In MySQL they're 'BLOB's not 'CLOB's, see http://dev.mysql.com/doc/refman/5.1/en/string-type-overview.html.

PB
http://www.artfulsoftware.com

-----

J A wrote:
Thanks!
With regard to the ClOBs or Text fields, is that CLOB support? Or support for Text columns that hold up to 60,000 bytes of TEXT data?



From: Peter Brawley <peter.brawley@earthlink.net>
Reply-To: peter.brawley@earthlink.net
To: J A <my_data_storage_65@hotmail.com>
CC: mysql@lists.mysql.com
Subject: Re: Some general questions
Date: Tue, 28 Feb 2006 12:44:08 -0600

/>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/mysql?unsub=My_Data_Storage_65@hotmail.com

_________________________________________________________________
Express yourself instantly with MSN Messenger! Download today - it's FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/