oracle =_=! length() and lengthb()

oracle的length()与lengthb()

length()计算字符数,

lengthb()计算字节数,

-----------------------------------------------------------

英文的project中出现了脏数据mess code,如下查询

select * from table1 where length(column1)<>lengthb(column1) and length(column1)*2<>lengthb(column1);