Re: Package utl_i18n
Date: Wed, 4 Jun 2008 07:50:24 -0700 (PDT)
Message-ID: <d4c60d1d-eab9-4c5f-83c2-ad5f309132e5@d45g2000hsc.googlegroups.com>
On Jun 4, 9:47 am, Łukasz <lukaszke..._at_gmail.com> wrote:
> I have problem which char-coding, I want convert data from 'CP852' to
> 'WIN1250' (I have file which data coding in 'CP852' and I want insert
> this data to DB (set coding 'WIN1250'), why my example doesn't work?
>
> DECLARE
> r raw(50);
> s varchar2(20);
> BEGIN
> s:='1234';
> r:=utl_i18n.string_to_raw(s,'CP852');
> s := UTL_I18N.RAW_TO_NCHAR(r,'WIN1250') ;
> dbms_output.put_line(s);
> end;
>
> Best regard £ukasz
Zle kody do Oracle charsets
Sprobuj:
create or replace procedure Test is
r raw(50);
s varchar2(20);
begin
s:='1234';
r:=utl_i18n.string_to_raw(s,'EE8PC852');
s := UTL_I18N.RAW_TO_NCHAR(r,'EE8MSWIN1250') ;
dbms_output.put_line(s);
end Test;
Zobacz:
http://download-uk.oracle.com/docs/cd/B32110_01/content.1013/b32191/globesup.htm
HTH
Thomas
Received on Wed Jun 04 2008 - 09:50:24 CDT