INCREASE the max blob size

#1 (**permalink**) 02-28-2008, 10:28 AM

Hello guys,

i am developing a web application where i am using mysql as my rdbms.
i was wondering if we can increase the max blob size that mysql can
handle; currently its 2M.

Thnx for the help!

cheers

#2 (**permalink**) 02-28-2008, 10:28 AM

Fad¥ wrote:
> Hello guys,
>
> i am developing a web application where i am using mysql as my rdbms.
> i was wondering if we can increase the max blob size that mysql can
> handle; currently its 2M.

Maybe switch to another type
LONGBLOB: 2^32 or 4294967296 bytes (4 GiB)

But I would have stored the data directly on the file system and only stored
the path in the database.

--

//Aho

#3 (**permalink**) 02-28-2008, 10:28 AM

thnx AHO for the suggestion! i will definitely consider the second
solution!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode