Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: how to select chars with ascii > 127 on different platforms

Re: how to select chars with ascii > 127 on different platforms

From: alederer <alederer_at_gmx.at>
Date: Mon, 11 Aug 2003 08:43:47 +0200
Message-ID: <3f373b3f@e-post.inode.at>


Bob Hairgrove wrote:
>
> There is probably a conversion in code pages taking place between
> Solaris and Windows. I don't know how you are connecting, but in ODBC
> you would typically use a "translation DLL" to correct the conversion.
>

The application is an embedded sql c++ program (precompiled with proc) and it connects using

exec sql connect :username identified by :password

     at :Database_Name using :database_string;

to the db on the windows server.

After the connect, I use two alter session command:

alter session set NLS_NUMERIC_CHARACTERS = '.,' alter session set current_schema='XXX'

Are there any translation DLL's in this case? How can I disable or control this translation?

Thanks
Andreas Lederer Received on Mon Aug 11 2003 - 01:43:47 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US