oracle 的 length函数与db2的length函数

jin_ok 2008-03-11 05:16:19

在oracle 中 select length('李琳') from dual 返回2
在db2 中select length('李琳') from sysibm.SYSDUMMY1 返回4
db2 有没有返回字符个数的length函数，像oracle一样？

...全文

958 2 打赏收藏转发到动态举报

写回复

用AI写文章

2 条回复

切换为时间正序

请发表友善的回复…

发表回复

若闻 2010-06-10

打赏
举报

LENGTH ( expression, CODEUNITS16/ CODEUNITS32/ OCTETS )

littleboys 2008-03-13

打赏
举报

Db2 9 已经有个这个函数

LENGTH ( expression, CODEUNITS16/ CODEUNITS32/ OCTETS )

CODEUNITS16, CODEUNITS32, or OCTETS Specifies the string unit of the result. CODEUNITS16 specifies that the result is to be expressed in 16-bit UTF-16 code units. CODEUNITS32 specifies that the result is to be expressed in 32-bit UTF-32 code units. OCTETS specifies that the result is to be expressed in bytes. If a string unit is explicitly specified, and if expression is not string data, an error is returned (SQLSTATE 428GC). If a string unit is specified as CODEUNITS16 or CODEUNITS32, and expression is a binary string or bit data, an error is returned (SQLSTATE 428GC). If a string unit is specified as OCTETS and expression is a binary string, an error is returned (SQLSTATE 42815). For more information about CODEUNITS16, CODEUNITS32, and OCTETS, see “String units in built-in functions” in “Character strings”.