Re: Characterset problem with Oracle

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> jg

--
@home.com is bogus.
Nope, no antitrust here: 
http://www.signonsandiego.com/uniontrib/20040910/news_1b10oracle.html