从 DB2 和 Oracle 角度看 CLOB 和 BLOB 的区别? [英] Difference between CLOB and BLOB from DB2 and Oracle Perspective?

问题描述

我对这两种数据类型非常着迷.根据 Oracle Docs，它们显示为如下:

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 ?

推荐答案

BLOB 适用于二进制数据(视频、图像、文档、其他)

BLOB is for binary data (videos, images, documents, other)

CLOB 用于大文本数据(text)

MySQL 的最大大小为 2GB

Maximum size on MySQL 2GB

Oracle 128TB 上的最大大小

Maximum size on Oracle 128TB

这篇关于从 DB2 和 Oracle 角度看 CLOB 和 BLOB 的区别?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！