Re: Characterset problem with Oracle

"Howard J. Rogers" <hjr_at_dizwell.com> wrote in message news:<41423571$0$15470$afc38c87_at_news.optusnet.com.au>...
> Joel Garry wrote:
>
> > zunilp_at_gmail.com (Sunil) wrote in message
> > news:<8e0c3fab.0409092136.5d43fb6c_at_posting.google.com>...
> >> Hi,
> >> I am working with Oracle 8i. The chracterset for the oracle database
> >> is AMERICAN_AMERICA.WE8ISO8859P1 and character set of my oracle client
> >> is also same. Everything is working fine. But when I try to insert a
> >> data which is available in MS_Word format into varchar2 or LONG field,
> >> one character (ie apostrophe ' present in Word) is not inserting
> >> properly.
> >> I tried with OraOLEDB.Oracle 8.1.7.3 and toad and oracle client. But
> >> all inserts data in ? form.
> >>
> >> Is this a problem with chractesrset?
> >> Does WE8ISO8859P1 is not supporting the apostrophe(or single quote)
> >> character present in Word?
> >> Then which is the appropriate characterset for this?
> >>
> >> I tried to change the datbase characterset to UTF8. but since UTF8 i
> >> snot a superset, oracle doesn't allow me.
> >>
> >> Can anyone help me in this case?
> >>
> >> Thanks & Regards
> >>
> >> SUnil P John
> >> Cordys
> >
> > Try it in sqlplus. Note the values:
> >
> > SQL> create table jjj (a varchar2(10));
> >
> > Table created.
> >
> > SQL> insert into jjj values ('''');
> >
> > 1 row created.
> >
> > SQL> select * from jjj;
> >
> > A
> > ----------
> > '
> >
> > SQL>
>
>
> I could be barking up the wrong tree, but the OP mentions Word documents.
> Word has that awful habit of auto-correcting things, and thus replacing "'"
> with "curly" apostrophes. I believe the curly version is an extended
> character, and you might well have trouble finding that represented in
> certain character sets.
>
> MSWIN1252 or whatever the default on Windows platforms will support them,
> but I doubt WE8ISO will.
>
> It could of course just be the proper 'escaping' of the character as you
> demonstrate.
>
> Regards
> HJR
Hi All,
Thanks for the help. As Howard pointed out, in Word, the single quote(') becomes ' which may be an extended character. Presently my datbase characterset and client characterset is WE8ISO8859P1.
Can I change it directly to WE8MSWIN1252? The client also I have to change to WE8MSWIN1252? Will it affect the existing data in any form? Will UTF8 charactesrset takes care all characters including this Word/Excel or Windows specific characters?

Hope you guys can help me.
Thanks once again

Sunil
Cordys Received on Mon Sep 13 2004 - 02:03:26 CDT