Herr Otto Partz wrote:
> Frank wrote:
>
>> Did you mean bit 8 (not bit 7) would be the MSB?
>> But as there's no 'room' for it (US7ASCII), it get's
>> dropped, set to 0. You cannot store characters with
>> the 8th bit set in a US7ASCII database.
>
>
> Sure you can. If you set the client charset to US7ASCII the Net8 (Net9?)
> protocol does not perform conversion and the diacritical characters are
> stored unchanged into the database.
>
> This is a test from the Linux shell:
>
> me_at_mywks:~> export NLS_LANG=AMERICAN_AMERICA.US7ASCII
> me_at_mywks:~> sqlplus un/pwd
>
> SQL*Plus: Release 9.0.1.0.0 - Production on Mon Apr 28 10:12:23 2003
>
> (c) Copyright 2001 Oracle Corporation. All rights reserved.
>
>
> Connected to:
> Oracle9i Enterprise Edition Release 9.0.1.3.0 - Production
> With the Partitioning option
> JServer Release 9.0.1.3.0 - Production
>
> SQL> desc x
> Name Null? Type
> ----------------------------------------- -------- ------------
> C VARCHAR2(10)
>
> SQL> insert into x values('àòèùà') ;
>
> 1 row created.
>
> SQL> select * from x ;
>
> C
> ----------
> àòèùà
>
> SQL>
>
Was the database created with US7ASCII? Nope.
It was, according to the OP
--
Regards, Frank van Bortel
Received on Mon Apr 28 2003 - 16:21:29 CDT
