Oracle plsql Demo-22. View the length of the string [LENGTHB, length] to determine if the string contains Chinese

--Count The length of stringSelectLENGTHB ('SELECT * from Scott.emp') asCountted_by_byte, Length ('SELECT * from Scott.emp') asCountted_by_char fromdual;--for some character encoding, the length () and the LENGTHB () are same in 中文版--feature to check whether the string constains the Chinese charDeclareV_charvarchar2( -) := 'Hello World Hi';begin    ifLENGTHB (V_char)=Length (V_char) ThenDbms_output.put_line ('It has not Chinese ...'); ElseDbms_output.put_line ('It has Chinese ...'); End if; End;

Oracle plsql Demo-22. View the length of the string [LENGTHB, length] to determine if the string contains Chinese