length()与lengthb()的区别
来源:互联网 发布:剑灵灵族女捏脸数据图 编辑:程序博客网 时间:2024/05/17 23:10
环境:oracle 11.1.0.6.0
区别:length计算字符长度,lengthb计算字节长度。
SQL> select length('a') from dual;
LENGTH('A')
-----------
1
SQL> select lengthb('a') from dual;
LENGTHB('A')
------------
1
SQL> select length('A') from dual;
LENGTH('A')
-----------
1
SQL> select lengthb('A') from dual;
LENGTHB('A')
------------
1
SQL> select length('你好') from dual;
LENGTH('你好')
--------------
2
SQL> select lengthb('你好') from dual;
LENGTHB('你好')
---------------
4
LENGTH
Purpose
The LENGTH
functions return the length of char
. LENGTH
calculates length using characters as defined by the input character set. LENGTHB
uses bytes instead of characters. LENGTHC
uses Unicode complete characters. LENGTH2
uses UCS2 code points. LENGTH4
uses UCS4 code points.
char
can be any of the datatypes CHAR
, VARCHAR2
, NCHAR
, NVARCHAR2
, CLOB
, or NCLOB
. The return value is of datatype NUMBER
. If char
has datatype CHAR
, then the length includes all trailing blanks. If char
is null, then this function returns null.
Restriction on LENGTHB The LENGTHB
function is supported for single-byte LOBs only. It cannot be used with CLOB
and NCLOB
data in a multibyte character set.
Examples
The following example uses the LENGTH
function using a single-byte database character set:
SELECT LENGTH('CANDIDE') "Length in characters" FROM DUAL;Length in characters-------------------- 7
The next example assumes a double-byte database character set.
SELECT LENGTHB ('CANDIDE') "Length in bytes" FROM DUAL; Length in bytes--------------- 14
- length()与lengthb()的区别
- oracle length与lengthb的区别
- Oracle中的length()与lengthb()的区别 ?
- oracle中length()与lengthb()区别
- oracle中length()与lengthb()区别
- LENGTH,LENGTHB,LENGTHC,LENGTH2,LENGTH4的区别!
- LENGTH,LENGTHB,LENGTHC,LENGTH2,LENGTH4的区别
- LENGTH,LENGTHB,LENGTHC,LENGTH2,LENGTH4的区别
- sql 函数length() 和lengthb()的区别
- oracle length 与 lengthb
- length()与lengthb()
- length()与lengthb()
- Oracle数据库的varchar2和nvarchar2、LENGTH 与 LENGTHB 的区别
- length 与 length()的区别
- childNodes.length与children.length的区别
- args.length与args...length的区别
- length与length()区别
- length,lengthb和substr,subtrab
- 读取的文件没有颜色问题 安装免安装的mysql
- 买符合复利滚动的小盘成长股(2009-07-14 10:07:34)
- 软件研发之需求分析(一)
- Python: 使用装饰器“@”取得函数执行时间
- 软件研发之需求分析(二)
- length()与lengthb()的区别
- 自說自話
- flex 图片滤镜效果实例
- TIM学习文档22-- 账户分配
- javascript 总结 《一》
- 百度2010校园招聘中的一道有意思的笔试题
- 让.Net程序脱离.net framework框架运行
- 笔试题及解答
- 哎,大家的东西要注意备份啊。。。