Re: replication: problem with character "degree" celcius

From: Charles Hooper <hooperc2000_at_yahoo.com>
Date: Tue, 12 Jun 2007 09:18:05 -0700
Message-ID: <1181665085.054744.192060@n15g2000prd.googlegroups.com>

On Jun 12, 7:46 am, sybrandb <sybra..._at_gmail.com> wrote:
> On Jun 12, 1:39 pm, Charles Hooper <hooperc2..._at_yahoo.com> wrote:
> > The problem appears to be that Oracle permitted your application to
> > store an 8 bit ASCII value in a 7 bit ASCII database: 176 > 127.
>
> > Charles Hooper
> > IT Manager/Oracle DBA
> > K&M Machine-Fabricating, Inc.
>
> This will happen if client is 7-bit ASCII AND server is 7-bit ASCII.
> In that case there will be no conversion and everything even > 128
> will pass.
>
> --
> Sybrand Bakker
> Senior Oracle DBA

Thanks for the explanation.

If the OP were to convert the source database from 7 bit ASCII to 8 bit ASCII (WE8ISO8859P1), would that resolve the problem without losing the existing high bit of the ASCII characters for ASCII characters >= 128, so that ASCII 176 does not become ASCII (176 - 128)?

Charles Hooper
IT Manager/Oracle DBA
K&M Machine-Fabricating, Inc. Received on Tue Jun 12 2007 - 11:18:05 CDT