Re: Package utl_i18n

From: Thomas Olszewicki <ThomasO_at_cpas.com>
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

Original text of this message