Re: Package utl_i18n

From: Thomas Olszewicki <ThomasO_at_cpas.com>
Date: Wed, 4 Jun 2008 07:58:41 -0700 (PDT)
Message-ID: <acb8729b-00e3-4418-90c0-ac10c4c2de24@34g2000hsh.googlegroups.com>


On Jun 4, 10:50 am, Thomas Olszewicki <Thom..._at_cpas.com> wrote:
> 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/g...
>
> HTH
> Thomas

Sorry,
By mistake I thought I was replaying to Polish group; My response should read:
"Wrong Oracle charset codes:
Try:
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;

Read this:
http://download-uk.oracle.com/docs/cd/B32110_01/content.1013/b32191/globesup.htm HTH
Thomas" Received on Wed Jun 04 2008 - 09:58:41 CDT

Original text of this message