/>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@stripped>
>> Reply-To: peter.brawley@stripped
>> To: J A <my_data_storage_65@stripped>
>> CC: mysql@stripped
>> 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=1
>
> _________________________________________________________________
> Express yourself instantly with MSN Messenger! Download today - it's
> FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/
>
>
>
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
