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.