File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes BLOB versus clob Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "BLOB versus clob" Watch "BLOB versus clob" New topic

BLOB versus clob

Surya Ram

Joined: Aug 09, 2004
Posts: 7
I have a TreeMap which I need to store it into the Database. I am right now using BLOB datatype by serializing the TreeMap. Could anybody suggest if we can use CLOB instead of BLOB?

Thank you,
Scott Dunbar
Ranch Hand

Joined: Sep 23, 2004
Posts: 245
No, I think you're doing the correct thing using a CLOB. There is binary data in a serialize Java class and you don't want the DB doing some character conversion for you when you least expect it.

<a href="" target="_blank" rel="nofollow">Java forums using Java software</a> - Come and help get them started.
I agree. Here's the link:
subject: BLOB versus clob
It's not a secret anymore!