| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Interesting Problem
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: SValuthur_at_erac.com
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: ListGuru_at_fatcity.com (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). Received on Fri Aug 24 2001 - 11:47:04 CDT
 |
 |