clob

Thread view:

Ike - 21 Nov 2004 14:58 GMT

Can someone tell me what a clob is, and how it differs from a blob? I am
about to write a document retrieval system using MySql Connector / J, and am
wondering what data type I should use for saving files which can vary
greatly in size, some of which can be a few megs even.

Thanks, Ike

Reply to this Message

Dieter Bender - 21 Nov 2004 19:16 GMT

Ike,

Blob is never translated, while clob might be transalted from one Codepage
to another.

Dieter Bender

> Can someone tell me what a clob is, and how it differs from a blob? I am
> about to write a document retrieval system using MySql Connector / J, and
> am wondering what data type I should use for saving files which can vary
> greatly in size, some of which can be a few megs even.
>
> Thanks, Ike

Reply to this Message

Murray - 22 Nov 2004 00:32 GMT

> Can someone tell me what a clob is, and how it differs from a blob? I am
> about to write a document retrieval system using MySql Connector / J, and
[quoted text clipped - 3 lines]
>
> Thanks, Ike

In general:

CLOBs are for character data, i.e. big strings, text files, XML, Base64 (or
other) encoded binary files etc.

BLOBs are for binary data.

Sounds like you'd want BLOBs unless you're only dealing with text files.

Reply to this Message

Ike - 22 Nov 2004 01:21 GMT

Can blobs handle data > 64 k in MySql Connector / J ? Thanks, Ike

> > Can someone tell me what a clob is, and how it differs from a blob? I am
> > about to write a document retrieval system using MySql Connector / J, and
[quoted text clipped - 12 lines]
>
> Sounds like you'd want BLOBs unless you're only dealing with text files.

Reply to this Message

Murray - 22 Nov 2004 02:00 GMT

> Can blobs handle data > 64 k in MySql Connector / J ? Thanks, Ike

In my experience: yes. Thought it might depend on the version. Why don't you
try it?

Reply to this Message

clob

Free Magazines