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 varchar2, clob and blob? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Java Interview Guide this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "varchar2, clob and blob?" Watch "varchar2, clob and blob?" New topic

varchar2, clob and blob?

ankur rathi
Ranch Hand

Joined: Oct 11, 2004
Posts: 3830
What is the difference between varchar2, clob and blob data type of SQL. Where we should what?

[ December 12, 2005: Message edited by: rathi ji ]
Jesper de Jong
Java Cowboy
Saloon Keeper

Joined: Aug 16, 2005
Posts: 15101

This is not a Java question, but a database specific SQL question.
Lookup VARCHAR, CLOB and BLOB in the documentation of your database.

Java Beginners FAQ - JavaRanch SCJP FAQ - The Java Tutorial - Java SE 8 API documentation
Sri Ram
Ranch Hand

Joined: Oct 03, 2005
Posts: 118
Googling on this give lots of Result
I agree. Here's the link:
subject: varchar2, clob and blob?
It's not a secret anymore!