File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and the fly likes what is Blob and Clob? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "what is Blob and Clob?" Watch "what is Blob and Clob?" New topic

what is Blob and Clob?

naidu gulla

Joined: Jul 19, 2006
Posts: 14
at which application Blob and Clob will be used.just i need some example
thanks in advance
Ulf Dittmer

Joined: Mar 22, 2005
Posts: 41599
Blob = Binary Large OBject, e.g. an image

Clob = Character Large OBject, e.g. a large chunk of text

They map to the SQL types of the same names.

Ping & DNS - my free Android networking tools app
naidu gulla

Joined: Jul 19, 2006
Posts: 14
thanku verymuch
i need some example can u give it.
thanks in advance
Mark Spritzler

Joined: Feb 05, 2001
Posts: 17250

This forum is for JBoss questions. Since this is a generic database question, I am actually going to move this to the JDBC forum


Perfect World Programming, LLC - Two Laptop Bag - Tube Organizer
How to Ask Questions the Smart Way FAQ
Scott Johnson
Ranch Hand

Joined: Aug 24, 2005
Posts: 518
i need some example can u give it.

What kind of example do you need? Create table statement? select? insert?

Which RDBMS? Some have special syntax for clobs/blobs.
I agree. Here's the link:
subject: what is Blob and Clob?