Re: Package utl_i18n
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