BLOB, CLOB and DBCLOB
来源:互联网 发布:itunes mac 下载路径 编辑:程序博客网 时间:2024/05/20 07:58
BLOB(n[K|M|G])
A BLOB (binary large object) is a variable-length binary string that can be up to 2 gigabytes (2 147 483 647 bytes) long.
If only n by itself is specified, the value of n is the maximum length. If K, M or G is specified the maximum length is 1 024, 1 048 576 or 1 073 741 824 times n, and the maximum value for n is 2 097 152, 2 048 or 2, respectively.
Binary large objects are used to hold data, such as pictures, video and audio. Like FOR BIT DATA character strings, BLOB strings are not associated with a code page.
CLOB(n[K|M|G])
A CLOB (character large object) is a variable-length character string that can be up to 2 gigabytes (2 147 483 647 bytes) long. If the length is zero, the value is called the empty string. This value should not be confused with the null value.
If only n by itself is specified, the value of n is the maximum length. If K, M or G is specified the maximum length is 1 024, 1 048 576 or 1 073 741 824 times n, and the maximum value for n is 2 097 152, 2 048 or 2, respectively.
Character large objects are used to store large SBCS's (single-byte character sets) character-based data such as formatted text, HTML and XML documents.
DBCLOB(n[K|M|G])
A DBCLOB (double-byte character large object) is a variable-length graphic string of double-byte characters that can be up to 1 073 741 823 characters long.
If only n by itself is specified, the value of n is the maximum length. If K, M or G is specified the maximum length is 1 024, 1 048 576 or 1 073 741 824 times n, and the maximum value for n is 1 048 576, 1 024 or 1, respectively.
Double-byte character large objects are used to store large DBCS's (double-byte character sets) character-based data.
- BLOB, CLOB and DBCLOB
- db2的大字段CLOB,BLOB,DBCLOB
- db2的大字段CLOB,BLOB,DBCLOB
- clob 、blob
- clob&blob
- CLOB、BLOB , CLOB与BLOB的区别
- CLOB、BLOB , CLOB与BLOB的区别
- CLOB、BLOB , CLOB与BLOB的区别
- CLOB、BLOB , CLOB与BLOB的区别
- CLOB、BLOB , CLOB与BLOB的区别
- hibernate 写入 clob, Blob
- oracle----blob vs clob
- Blob,Clob字段
- Blob 和 Clob
- Blob he Clob (二)
- BLOB 和CLOB
- blob与clob
- 处理lob(blob, clob)
- 如何配置实现管理软件的开发
- 移动小电脑猛增,Linux平台占优
- NET3.5环境安装终究是否要上网?
- 不同服务器数据库之间的数据操作(2)
- Shell脚本 学习
- BLOB, CLOB and DBCLOB
- Apache服务器指令大全
- 低价笔记本:搏杀产业链
- 自动检测apache运行状态
- 闭关修炼,更上一层
- ACCESS 三表左连接为什么出错呢
- 用友ERP V8.71实施
- 给学Java的大学生们分享一些经验 (转自中国IT实验室--天生我材必有用)
- 无盘系统怎么做