SQL CLOB 和 NCLOB 有什么区别？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/6854609/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
What is the difference between CLOB and NCLOB?
提问by Loga
Can you state any difference between the CLOB and NCLOB?
你能说出 CLOB 和 NCLOB 之间的任何区别吗？
回答by Justin Cave
A CLOB stores character data encoded in the database character set. A NCLOB stores character data encoded in the national character set
CLOB 存储在数据库字符集中编码的字符数据。NCLOB 存储以国家字符集编码的字符数据
SELECT parameter, value
FROM v$nls_parameters
WHERE parameter LIKE '%CHARACTERSET'
will show you the database and national character sets of your database.
将显示您的数据库的数据库和国家字符集。
回答by rajesh
BLOB, CLOB, NCLOB and BFILE The built-in LOB data types BLOB, CLOB and NCLOB (stored internally), and BFILE (stored externally), can store large and unstructured data such as text, images and spatial data up to 4 gigabytes in size.
BLOB、CLOB、NCLOB 和 BFILE 内置的 LOB 数据类型 BLOB、CLOB 和 NCLOB（内部存储）和 BFILE（外部存储）可以存储大型非结构化数据，例如文本、图像和空间数据，最大为 4 GB尺寸。
BLOB
BLOB
The BLOB data type stores binary large objects. BLOB can store up to 4 gigabytes of binary data.
BLOB 数据类型存储二进制大对象。BLOB 最多可以存储 4 GB 的二进制数据。
CLOB
CLOB
The CBLOB data type stores character large objects. CLOB can store up to 4 gigabytes of character data.
CBLOB 数据类型存储字符大对象。CLOB 最多可以存储 4 GB 的字符数据。
NCLOB
NCLOB
The NCBLOB data type stores character large objects in multibyte national character set. NCLOB can store up to 4 gigabytes of character data.
NCBLOB 数据类型以多字节国家字符集存储字符大对象。NCLOB 最多可以存储 4 GB 的字符数据。
BFILE
文件
The BFILE data type enables access to binary file LOBs that are stored in file systems outside the Oracle database. A BFILE column stores a locator, which serves as a pointer to a binary file on the server's file system. The maximum file size supported is 4 gigabytes.
BFILE 数据类型允许访问存储在 Oracle 数据库之外的文件系统中的二进制文件 LOB。BFILE 列存储一个定位器，它用作指向服务器文件系统上的二进制文件的指针。支持的最大文件大小为 4 GB。
