Re: real limit of BLOBs

2001-03-15 Thread Fred van Engen
On Tue, Mar 13, 2001 at 04:18:41PM +0100, Alessandro de Manzano wrote: > I'm planning to deploy MySQL for a project of my company but I've some > concern about real size limit of BLOBs. > > I read on Paul DuBois' excellent book that longblob are 2^32-1 wide, > but actually the communication _prot

Re: real limit of BLOBs

2001-03-13 Thread Peter Szekszardi
Hi, > I read on Paul DuBois' excellent book that longblob are 2^32-1 wide, > but actually the communication _protocol_ between clients and server > limits to 24Mb the dimension of a single record. > > What workarounds could I use ? A simple workaround is that you store the binary data as files o

real limit of BLOBs

2001-03-13 Thread Alessandro de Manzano
Hello! I'm a beginner of the wonderful world of MySQL :-) I'm planning to deploy MySQL for a project of my company but I've some concern about real size limit of BLOBs. situation: MySQL 3.23.33 on FreeBSD 4.2-stable, clients are near always Win machines with MyODBC and proprietary software.