SQL & PL/SQL

Hi

I have an issue with one function which used to work perfectly when the characterset of the database was al32utf8 ,
Now we have changed the characterset to ar8mswin1256 , due to use of arabic language in the application.

Below is the function

 

CREATE OR REPLACE FUNCTION fn_get_string_lang(pv_string VARCHAR2)
  RETURN VARCHAR2 AS
  v_str_type VARCHAR2(2):='E';
BEGIN
  FOR i IN 1..length(pv_string)
    LOOP
      IF (ascii(SUBSTR(pv_string,i,1)) > 256) THEN
        v_str_type := 'A';
        EXIT;
      END IF;
    END LOOP;
    RETURN v_str_type;
EXCEPTION
  WHEN OTHERS THEN
    insert_error(-123, SQLERRM, NULL, NULL, 'fn_get_string_lang');
    RETURN 'E';
END fn_get_string_lang;

In the above function we check if the characters entered are in arabic.... this used to work in al32utf8 , but nit now.

Please Help.