with MySQL, TEXT is for text and BLOB is for binary data.
type max. storage size
TINYBLOB, TINYTEXT 2^8
BLOB, TEXT 2^16
MEDIUMBLOB, MEDIUMTEXT 2^24
LONGBLOB, LONGTEXT 2^32
> -----Original Message-----
> From: infoz [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, June 26, 2001 9:29 AM
> To: Michael Champagne
> Cc: PHP General Mailing List
> Subject: Re: [PHP] Help with PHP/Oracle and serializing data
>
>
> In Oracle, 'long' is a variable-length character data column up to 2GB in
> size. Roughly equivalent to 'text' in mysql, I think. You can also use
> 'blob', 'clob' and/or 'nclob' instead, but I think access to those types is
> less straightforward than the 'long' type.
>
> - Tim
> http://www.phptemplates.org
>
> > Thanks for the response. I'm kind of confused though. You can use a
> 'long'
> > type for a string of characters greater than 4k?
>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
