Size of BLOB types?

2005-04-16 Thread Dan Bolser
The manual dosn't specify the maximum number of characters in the TINYTEXT, TEXT, MEDIUMTEXT, and LONGTEXT data types. http://dev.mysql.com/doc/mysql/en/blob.html Are these valid synonyms, TINYBLOB, MEDIUMBLOB and LONGBLOB? I have a field with just under 1000 characters, am I OK with a

Re: Size of BLOB types?

2005-04-16 Thread Hassan Schroeder
Dan Bolser wrote: The manual dosn't specify the maximum number of characters in the TINYTEXT, TEXT, MEDIUMTEXT, and LONGTEXT data types. http://dev.mysql.com/doc/mysql/en/blob.html Are these valid synonyms, TINYBLOB, MEDIUMBLOB and LONGBLOB? The very beginning of the cited page is: q A BLOB is a

Re: Size of BLOB types?

2005-04-16 Thread Dan Bolser
On Sat, 16 Apr 2005, Hassan Schroeder wrote: Dan Bolser wrote: The manual dosn't specify the maximum number of characters in the TINYTEXT, TEXT, MEDIUMTEXT, and LONGTEXT data types. http://dev.mysql.com/doc/mysql/en/blob.html Are these valid synonyms, TINYBLOB, MEDIUMBLOB and LONGBLOB?

Re: Size of BLOB types?

2005-04-16 Thread Robert Dunlop
@lists.mysql.com Sent: Saturday, April 16, 2005 1:49 PM Subject: Re: Size of BLOB types? On Sat, 16 Apr 2005, Hassan Schroeder wrote: Dan Bolser wrote: The manual dosn't specify the maximum number of characters in the TINYTEXT, TEXT, MEDIUMTEXT, and LONGTEXT data types. http://dev.mysql.com/doc/mysql/en

Re: Size of BLOB types?

2005-04-16 Thread Dan Bolser
respect to hold at least 65536 characters! Thanks for the pointers so far, Dan. - Original Message - From: Dan Bolser [EMAIL PROTECTED] To: Hassan Schroeder [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Sent: Saturday, April 16, 2005 1:49 PM Subject: Re: Size of BLOB types? On Sat, 16

Re: Size of BLOB types?

2005-04-16 Thread Hassan Schroeder
Dan Bolser wrote: FWIW? For What It's Worth... Naturally I followed that link, but was unable to understand (or piece together) the information there in. Storage Requirements for String Types: (or maximum length of BLOB types for dummies) Not exactly -- storage requirements include the DB

Re: Size of BLOB types?

2005-04-16 Thread Robert Dunlop
, April 16, 2005 2:22 PM Subject: Re: Size of BLOB types? On Sat, 16 Apr 2005, Robert Dunlop wrote: Your question was would a TINYBLOB hold 1,000 characters. TINYBLOB (TINYTEXT) = 257 characters. 1,000 257 = No. Your next option, BLOB (TEXT) = 64K. 1,000 64K = Yes. Yeah, I got that part, more

Re: Size of BLOB types?

2005-04-16 Thread Dan Nelson
In the last episode (Apr 16), Dan Bolser said: The manual dosn't specify the maximum number of characters in the TINYTEXT, TEXT, MEDIUMTEXT, and LONGTEXT data types. http://dev.mysql.com/doc/mysql/en/blob.html At the top of that page: The four TEXT types, TINYTEXT, TEXT, MEDIUMTEXT, and

Re: Size of BLOB types?

2005-04-16 Thread Dan Bolser
Beautiful! Cheers, (one and all), Dan. On Sat, 16 Apr 2005, Dan Nelson wrote: In the last episode (Apr 16), Dan Bolser said: The manual dosn't specify the maximum number of characters in the TINYTEXT, TEXT, MEDIUMTEXT, and LONGTEXT data types. http://dev.mysql.com/doc/mysql/en/blob.html