- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
What is the difference between BLOB and CLOB datatypes?
Blob and Clob together are known as LOB(Large Object Type). The following are the major differences between Blob and Clob data types.
Blob | Clob |
---|---|
The full form of Blob is a Binary Large Object. | The full form of Clob is Character Large Object. |
This is used to store large binary data. | This is used to store large textual data. |
This stores values in the form of binary streams. | This stores values in the form of character streams. |
Using this you can stores files like videos, images, gifs, and audio files. | Using this you can store files like text files, PDF documents, word documents etc. |
MySQL supports this with the following datatypes:
| MySQL supports this with the following datatypes:
|
In JDBC API it is represented by java.sql.Blob Interface. | In JDBC it is represented by java.sql.Clob Interface. |
The Blob object in JDBC points to the location of BLOB instead of holding its binary data. | The Blob object in JDBC points to the location of BLOB instead of holding its character data. |
To store Blob JDBC (PreparedStatement) provides methods like:
| To store Clob JDBC (PreparedStatement) provides methods like:
|
And to retrieve (ResultSet) Blob it provides methods like:
| And to retrieve (ResultSet) Clob it provides methods like:
|
- Related Articles
- What are the differences between the BLOB and TEXT datatypes in MySQL?
- Difference between Primitive and non-primitive datatypes in JavaScript?
- How to Read data from BLOB and CLOB type columns from a table using JDBC?
- How to write data into BLOB and CLOB type columns in a table using JDBC?
- What is the C# Equivalent of SQL Server DataTypes?
- What is the difference between = and: = assignment operators?
- What is the difference between IAS and IPS?
- What is the difference between g++ and gcc?
- What is the difference between Hinduism and Buddhism?
- What is the difference between SQL and MySQL?
- What is the difference between Liter and Litre?
- What is the difference between ODBC and JDBC
- What is the difference between $ and @ in R?
- What is the difference between jQuery and JavaScript?
- What is the difference between jQuery.size() and jQuery.length?

Advertisements