从DB2和Oracle角度看，CLOB和BLOB之间有区别吗? [英] Difference between CLOB and BLOB from DB2 and Oracle Perspective?
问题描述
这两种数据类型让我非常着迷.根据 Oracle文档 ，它们表示为如下:
I have been pretty much fascinated by these two data types. According to Oracle Docs, they are presented as follows :
BLOB::可变长度的二进制大对象字符串，最长可为2GB(2,147,483,647).主要用于保存非传统数据，例如语音或混合媒体.与FOR BIT DATA字符串一样，BLOB字符串也不与字符集关联.
BLOB : Variable-length binary large object string that can be up to 2GB (2,147,483,647) long. Primarily intended to hold non-traditional data, such as voice or mixed media. BLOB strings are not associated with a character set, as with FOR BIT DATA strings.
CLOB::长度可变的大对象字符串，最长可为2GB(2,147,483,647). CLOB可以存储单字节字符串或多字节基于字符的数据. CLOB被认为是字符串.
CLOB : Variable-length character large object string that can be up to 2GB (2,147,483,647) long. A CLOB can store single-byte character strings or multibyte, character-based data. A CLOB is considered a character string.
我不知道，从DB2和Oracle角度来看，两者之间是否有任何区别?我的意思是，DB2 CLOB和Oracle CLOB之间以及DB2 BLOB和Oracle BLOB之间有什么区别? DB2和Oracle的最大大小是多少?只是2 GB吗?
What I don't know, is whether there is any difference between the two from DB2 and Oracle perspective? I mean, what are the differences between DB2 CLOB and Oracle CLOB, also between DB2 BLOB and Oracle BLOB? What is the maximum size of both in DB2 and Oracle? Is it just 2 GB ?
推荐答案
它们可以被认为是等效的.大小限制是相同的:
They can be considered as equivalent. The limits in size are the same:
- CLOB的最大长度(以字节或OCTETS为单位)2147483647
- BLOB的最大长度(以字节为单位)2147483647
还有用于双字节字符的DBCLOB.
There is also the DBCLOBs, for double byte characters.
参考文献:
- LOB definition in DB2: http://pic.dhe.ibm.com/infocenter/db2luw/v10r5/topic/com.ibm.db2.luw.sql.ref.doc/doc/r0008473.html
- SQL and XML limits: http://pic.dhe.ibm.com/infocenter/db2luw/v10r5/topic/com.ibm.db2.luw.sql.ref.doc/doc/r0001029.html
这篇关于从DB2和Oracle角度看，CLOB和BLOB之间有区别吗?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
