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
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 16M. This will prevent any > si

Re: MYSQL and large fields

2002-12-03 Thread Roger Baklund
* 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 16M. This will prevent any single field from containing more than 16M. This limitati

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 MySQ