Re: Why Win3.1 clients saw only 7bit data of a Unix Server's 8bit data tables ? How to solve it?

Hung Nguyen wrote:
>
> We had tables with 8-bit characters fields (non-English character set) on an
> Oracle Server 7.0 (running on SCO Unix)
>
> Access these tables from another SCO Unix clients (Sqlplus, eg.), we got the
> data in full 8-bit set.
>
> But from plus31.exe (Sqlplus client) or Oracle Form4.5 on MS Windows, we cannot
> obtain the required characters (It seemed to be stripped off into 7-bit chars)
> though we had changed to use the appropriate windows fonts
>
> We configured our NLS* options as US-English, this should not affect the data,
> we thought, since they are used to load the Oracle messages only, Is it right ?
>
> Thank you on advance for your advices how to fix this. Pls mail me at
> hung_at_van.oz.au and/or to this newsgroup

The ORACLE.INI parameter NLS_LANG has two components. The second is the character set. For example, I heve it set as follows, as I use the ISO 8859/1 eight bit character set. The default is 7-bit ASCII.  

NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1 Charles Jardine - University of Cambridge (UK) Computing Service. Received on Fri Mar 08 1996 - 00:00:00 CET