top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

What is CLOB and BLOB datatypes in JDBC?

0 votes
222 views
What is CLOB and BLOB datatypes in JDBC?
posted Aug 22, 2017 by anonymous

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

Character Large OBjects (CLOBs) are character string made up of single-byte characters with an associated code page. This data type is appropriate for storing text-oriented information where the amount of information can grow beyond the limits of a regular VARCHAR data type (upper limit of 32K bytes).

Binary Large OBjects (BLOBs) are binary string made up of bytes with no associated code page. This data type can store binary data larger than VARBINARY (32K limit). This data type is good for storing image, voice, graphical, and other types of business or application-specific data.

answer Aug 23, 2017 by Sourav Kumar
Similar Questions
+3 votes

Which JDBC Driver class is used by ojdbc14.jar(Oracle11g) and jconn-7.0 jar(Sybase ASE 15.7) ?
As we know there are 4 different types of JDBC Driver types are present, such as

  1. JDBC-ODBC Bridge Driver
  2. Native-API Driver
  3. Network Protocol Driver
  4. Thin Driver
...