Posted by Hilarion on 10/04/33 11:37

> what type is a CLOB (couldn't find it in MySQL 5.0 manual)? an Oracle type?

I know this type from Oracle. I do not use MySQL, so I'm not sure how this
type translates to MySQL types. CLOB in Oracle is a character type for long texts.
VARCHAR / CHAR types in Oracle (at least in the versions I used) are
limited to (AFAIR) 4000 characters. CLOB has only a filesystem limit
(or 2GB on older Oracles). The flaw of CLOB type is that normal text
operators and functions do not work with it.


> BTW, what would drive the decision to choose between BLOB, LONGBLOB, and
> BINARY? I know between BLOB and LONGBLOB it's data size. but I don't
> know much about BINARY and its difference from BLOB. Isn't BLOB and
> LONGBLOB just a type of BINARY, where BINARY is the internal representation
> type?

As I said I do not use MySQL, so I can't help in this case.


Hilarion

• Next in forum: code stays hidden ... right ?
• Prev in forum: Re: file download is php script (to be able to log) but doesn't always appear to work ?
• Thread view: Re: before I have a break down

[Reply to this message]