This week's book giveaway is in the Android forum.
We're giving away four copies of Head First Android and have Dawn & David Griffiths on-line!
See this thread for details.
The moose likes JDBC and Relational Databases 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 Head First Android this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
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: 42956
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.
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: 17271

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?
It's not a secret anymore!