Shulou(Shulou.com)05/31 Report--

This article introduces the relevant knowledge of "what are the differences between clob and blob in oracle". In the operation of actual cases, many people will encounter such a dilemma, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

The difference between clob and blob in oracle: BLOB, whose full name is binary large object, is stored according to binary, and is usually used to convert pictures, files, music and other information into binary and then store it; while CLOB, whose full name is character large object, stores text directly and is usually used to store articles or longer text directly.

The operating environment of this tutorial: Windows10 system, Oracle 11g version, Dell G3 computer.

What is the difference between clob and blob in oracle

BLOB is used to store binary data, while CLOB is used to store text.

1.BLOB

BLOB is called binary large object (Binary Large Object). It is used to store large binary objects in the database. The maximum storage size is 4G bytes

2.CLOB

CLOB is called character large object (Character Large Object). It is similar to the LONG data type, except that CLOB is used to store large single-byte character blocks in the database and does not support character sets of varying widths. The maximum storage size is 4G bytes

BLOB and CLOB are both large field types. BLOB is stored in binary, while CLOB can store text directly. In fact, the two are interchangeable, or you can directly replace them with LOB fields.

However, in order to better manage the ORACLE database, information such as pictures, files, music and so on are usually stored in BLOB fields, and the files are first converted to binary and then stored. For example, articles or longer text are stored in CLOB, which provides great convenience for future query, update, storage and other operations.

This is the end of the content of "what is the difference between clob and blob in oracle". Thank you for reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.