Oracle PLSQL Demo，

Oracle PLSQL Demo，

--Count the length of string
select lengthb('select * from scott.emp') as countted_by_byte, length('select * from scott.emp') as countted_by_char from dual;

--For some character encoding, the length() and the lengthb() is same in english
--you may use this feature to check whether the string constains the chinese char
declare 
  v_char varchar2(50) := 'hello world你好';
begin
  
  if lengthb(v_char) = length(v_char) then
    dbms_output.put_line('it have not chinese...');
  else 
    dbms_output.put_line('it have chinese...');
  end if;
  
end;