oraclelength與lengthb的區別

oraclelength與lengthb的區別

區別：length求得是字符長度，lengthb求得是字節長度。

 
SQL> select length('哈哈') from dual t;
 
  LENGTH('哈哈')
--------------
             2
 
SQL> select lengthb('哈哈') from dual t;
 
  LENGTHB('哈哈')
---------------
              4