Re: MYSQL and large fields

2002-12-04 Thread Roger Baklund
* Thomas Spahni > On Tue, 3 Dec 2002, Roger Baklund wrote: > > > * Simon Green > > > A LONGBLOB can store 4294967295 bytes > > > A LONGTEXT can srote 4294967295 bytes > > > > In theory, yes. But not for real. MySQL 3.23.x has a limitation on > > the max_allowed_packet parameter, the max setting is

Re: MYSQL and large fields

2002-12-04 Thread Thomas Spahni
> http://www.mysql.com/doc/en/Packet_too_large.html > > > > -Original Message- > > From: Grant Cooper [mailto:[EMAIL PROTECTED]] > > Sent: 03 December 2002 11:20 > > To: [EMAIL PROTECTED] > > Subject: MYSQL and large fields > > > > > > We have swi

Re: MYSQL and large fields

2002-12-03 Thread Roger Baklund
. This limitation was removed in 4.0.1. http://www.mysql.com/doc/en/Packet_too_large.html > > -Original Message- > From: Grant Cooper [mailto:[EMAIL PROTECTED]] > Sent: 03 December 2002 11:20 > To: [EMAIL PROTECTED] > Subject: MYSQL and large fields > > > We have switc

RE: MYSQL and large fields

2002-12-03 Thread Simon Green
A LONGBLOB can store 4294967295 bytes A LONGTEXT can srote 4294967295 bytes Simon Green -Original Message- From: Grant Cooper [mailto:[EMAIL PROTECTED]] Sent: 03 December 2002 11:20 To: [EMAIL PROTECTED] Subject: MYSQL and large fields We have switched over from Microsoft Access to

MYSQL and large fields

2002-12-03 Thread Grant Cooper
We have switched over from Microsoft Access to MySQL because we were unable to store large files. 2-3 pages of written text. But M. Access kept messing with the data. MySQL has Blob types that can store large amounts of Data. So, can MySQL store 2-3 pages of text or would this be a limitation. I h