MySQL Forums
Forum List  »  Newbie

Re: Oracle CLOB in MySQL?
Posted by: Vikrama Sanjeeva
Date: February 03, 2009 10:38AM

Actually, the web application which I am using retrieves data from MySQL. When this app is connected with Oracle, it fails to read/write BLOCB cols. Thats the reason I converted this column type from BLOB to CLOB.

Now, you are saying to use "LONGBLOB". And I doubt the same, that web application will fail to read/write LONGBLOB column in MySQL.

Currently, web app is connected to MySQL and column type is TEXT. But I just saw on internet that TEXT supports max of 65,000 bytes. Which is not good in my case. I want to increase the size of TEXT column so that It can support 1 GB at least.

TEXT Limit: http://simonwillison.net/2002/Aug/1/mysqlTextLimits/

Here is the script

*****
CREATE TABLE `My_Table` (
`CONTENT` int(11) NOT NULL,
`My_COL` text
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
*****

Now How can I maintain TEXT type of MY_COL but enable it to support 1GB ?

Thanks.
Bye
Viki



Edited 1 time(s). Last edit at 02/03/2009 10:40AM by Vikrama Sanjeeva.

Options: ReplyQuote


Subject
Written By
Posted
February 03, 2009 09:37AM
February 03, 2009 09:45AM
Re: Oracle CLOB in MySQL?
February 03, 2009 10:38AM
February 03, 2009 12:42PM
February 23, 2009 02:16AM
February 24, 2009 12:03AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.