Re: Characterset problem with Oracle

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Sat, 11 Sep 2004 09:14:47 +1000
Message-ID: <41423571$0$15470$afc38c87@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 Received on Fri Sep 10 2004 - 18:14:47 CDT