Re: Package utl_i18n

From: Łukasz <lukaszkecik_at_gmail.com>
Date: Wed, 4 Jun 2008 10:41:48 -0700 (PDT)
Message-ID: <a55e6f61-b4b9-4122-b21f-ee0dbb401d7b@27g2000hsf.googlegroups.com>


On 4 Cze, 16:58, Thomas Olszewicki <Thom..._at_cpas.com> wrote:
> 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/g...
> HTH
> Thomas"

Thanx a lot/Dzięki jutro przetestuję :) Received on Wed Jun 04 2008 - 12:41:48 CDT

Original text of this message