encrypt Chinese or Japanese(B

From: yongjia(B <yongjia_at_hotmail.com>
Date: Thu, 28 Dec 2006 15:19:21 +0800
Message-ID: <emvtn1$pgm$1_at_news.cn99.com>

[Quoted] hi all:

I use dbms_obfuscation_toolkit.desencrypt to encrypt Chinese or Japanese vbstring
but when I decrypt it ,I can not get the right string

who can tell me how to resolve it?

---

create or replace function get_encrypted_string(orgstr varchar2) return varchar2 as

keystr varchar2(8) := 'angoukey';
encstr varchar2(40);
v_text varchar2(40);

begin
v_text := rpad( orgstr, (trunc(length(orgstr)/8)+1)*8, chr(0));

if orgstr is null then

   return null;
end if;

dbms_obfuscation_toolkit.desencrypt(
input_string => v_text,
key_string => keystr,
encrypted_string => encstr
);

return encstr;
end;

create or replace function get_decrypted_string(encstr varchar2) return varchar2 as
keystr varchar2(8) := 'angoukey';
orgstr varchar2(40);

begin
if encstr is null then

   return null;
end if;

dbms_obfuscation_toolkit.desdecrypt(
input_string => encstr,
key_string => keystr,
decrypted_string => orgstr
);

return rtrim(orgstr,chr(0));
end; Received on Thu Dec 28 2006 - 08:19:21 CET