aspose file tools*
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 Java 8 in Action this week in the Java 8 forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "what is Blob and Clob?" Watch "what is Blob and Clob?" New topic
Author

what is Blob and Clob?

naidu gulla
Greenhorn

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
Marshal

Joined: Mar 22, 2005
Posts: 39578
    
  27
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 - updated with new look and Ping home screen widget
naidu gulla
Greenhorn

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

Joined: Feb 05, 2001
Posts: 17249
    
    6

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

Mark


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