List:General Discussion« Previous MessageNext Message »
From:Peter Brawley Date:February 28 2006 8:05pm
Subject:Re: Some general questions
View as plain text  
/>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
Thread
Some general questionsJ A28 Feb
  • Re: Some general questionsMartijn Tonies28 Feb
  • Re: Some general questionsPeter Brawley28 Feb
    • Re: Some general questionsJ A28 Feb
      • Re: Some general questionsPeter Brawley28 Feb
    • Re: Some general questionsPeter Brawley1 Mar