Srikanth,
What is the NLS_LANG setting of the clients using the
front-end app? Sounds like they're set to US7ASCII so
they would automatically replace any extended ascii
characters with a '?'.
I know at one point the default NLS_LANG setting for
Windows clients was US7ASCII, but I can't remember
when it changed.
HTH,
-- Anita
--- "Valuthur, Srikanth" <[EMAIL PROTECTED]> wrote:
> Hi all,
>
> I am sure someone should be able to help me on this.
> I am having a user
> having problem when inserting a data that is from
> Legacy Systems into
> oracle. His 'Cent' symbol getting converted to
> Inverted 'Question Mark'.
> NOw everthing is 'cent' until it goes into database.
> Oracle suggested me to
> do some tests based on NLS VAriables being set. NOw
> when I set those and
> tried on backend thru sqlplus/sql loader the tests
> come out successful as
> 'cent'. But If I dont set the NLS_Variables, It
> sets it as Quote mark.
> The Developer said that setting NLS did not work for
> him as he had bulk load
> of programs that uses triggers and other things...
>
> The big question here is 1. Should NLS parameter
> setting be a part of Oracle
> Parameters for day to day usage. 2. How do we
> incorprate this to the front
> end as the load is coming via the front end? 3. Is
> this a known problem or
> bug?
>
> Let me know some suggestions as this is bugging my
> head
>
> Thanx
>
> Srikanth
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Valuthur, Srikanth
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
--------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
__________________________________________________
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: A. Bardeen
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
