character sets and pound sign
From: Chris Gadsby <chris_gadsby_at_compuserve.com>
Date: Mon, 17 May 1999 12:10:43 +0100
Message-ID: <OXWtYOFo#GA.397_at_nih2naab.prod2.compuserve.com>
Can anyone help please ????
Date: Mon, 17 May 1999 12:10:43 +0100
Message-ID: <OXWtYOFo#GA.397_at_nih2naab.prod2.compuserve.com>
Can anyone help please ????
I have an oracle 7.1 system with both dos and windows clients. If I enter character data containing the pound sign (£) there is a difference depending if it is entered via do or via a windows client. At the moment the dos system is fine and uses ascii(156) for a £ sign. By default the windows client uses ascii(63) which doesn't seem to translate correctly.
I'm sure the solution is somewhere in the nls parameters but I don't know where.
Can anyone help??
My MS SQL Server database has no problems - both the dos and windows MS-SQL clients pass the £ sign as ascii(156) - so there are no problems with that.
Thanks for any hints
Regards
Chris Gadsby Received on Mon May 17 1999 - 13:10:43 CEST