wood burning stoves 2.0*
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
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: 41108
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: 17249

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.
It is sorta covered in the JavaRanch Style Guide.
subject: what is Blob and Clob?
Similar Threads
conversion between CLOB/BLOB and String
Image insertion into database through JPA
Blob and Clob in iBatis
XML, flat files to database
how to download a zip file from database?