On Jun 12, 1:39 pm, Charles Hooper <hooperc2..._at_yahoo.com> wrote:
> On Jun 12, 6:03 am, Daud <dau..._at_hotmail.com> wrote:
>
> > Source database characterset US7ASCII (9.2.0.7.0)
> > Target database characterset WE8ISO8859P1 (9.2.0.8.0)
>
> > Have done the following:
>
> > 1 - set NLS_LANG to AMERICAN_AMERICA.US7ASCII on target database
> > 2 - set ORA_NLS33 variable on target database
>
> > The character above still appear as "?" in the target database. What
> > do I need to do to solve this?
>
> > Thanks
>
> > Daud
>
> US7ASCII supports a maximum of 7 bits per character, allowing a
> maximum ASCII value of 127 (2^7 - 1):
> SELECT
> POWER(2,7)-1 MAX_CHR,
> CHR(176),
> ASCII('°')
> FROM
> DUAL;
>
> SQL*Plus (Windows version):
> MAX_CHR C ASCII('°')
> ---------- - ----------
> 127 ° 176
>
> SQL*Plus (DOS Command line version):
> SQL> SELECT
> 2 POWER(2,7)-1 MAX_CHR,
> 3 CHR(176),
> 4 ASCII('°')
> 5 FROM
> 6 DUAL;
>
> MAX_CHR C ASCII(' ')
> ---------- - ----------
> 127 248
>
> 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
Received on Tue Jun 12 2007 - 06:46:32 CDT
