Home » Other » General » Oracle character set? (Oracle 10g R2)
Oracle character set? [message #498557] Thu, 10 March 2011 04:46 Go to next message
antenc
Messages: 13
Registered: September 2009
Location: UK
Junior Member
Good morning,

I have been wracking my brains on this one, so I am hoping that someone has come across this at some point.

We have 2 databases - Dev and Live, which look identical, in that I have checked the NLS_DATABASE_PARAMETERS and they're the same.

I am using Business Objects to load flat files into the DB, and where we have characters like '£', in one database they're being changed and appear in the Dev DB table as '¿', and on Live they appear as '???'. This has caused problems with field lengths, which now that they've been increased, we can see the data, which has left us a bit confused.

Has anyone seen this before?

Thanks in advance,

Carl
Re: Oracle character set? [message #498561 is a reply to message #498557] Thu, 10 March 2011 04:54 Go to previous messageGo to next message
Michel Cadot
Messages: 68055
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Business Object NLS_LANG is different in both case.

Regards
Michel
Re: Oracle character set? [message #498566 is a reply to message #498561] Thu, 10 March 2011 05:08 Go to previous messageGo to next message
antenc
Messages: 13
Registered: September 2009
Location: UK
Junior Member
Hi Michel,

Thanks for your reply. I am using the same Business Objects Data Integrator WF for both on 1 server. Where is the NLS_LANG set in BODI?

Regards,

Carl
Re: Oracle character set? [message #498568 is a reply to message #498557] Thu, 10 March 2011 05:14 Go to previous messageGo to next message
famegaurav
Messages: 23
Registered: November 2010
Location: Delhi India
Junior Member
Please answer:

- Are these plain old "text" flat files?

- What is the character set of the server?

- Could these be MS-Word "doc" files?

Re: Oracle character set? [message #498573 is a reply to message #498568] Thu, 10 March 2011 05:34 Go to previous messageGo to next message
antenc
Messages: 13
Registered: September 2009
Location: UK
Junior Member


- Yes, they're CSV files separated by |

- I'm not sure how to check the character set on a Unix server ?

- No

Cheers,

Carl
Re: Oracle character set? [message #498706 is a reply to message #498557] Thu, 10 March 2011 20:25 Go to previous messageGo to next message
demsaoroi88
Messages: 2
Registered: March 2011
Junior Member
we can see the data, which has left us a bit confused?
Re: Oracle character set? [message #498718 is a reply to message #498706] Thu, 10 March 2011 21:14 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>we
WE? Who are you?
>can see the data,
See what data where?
>which has left us a bit confused?
Now this make 4 of us confused!

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/
Re: Oracle character set? [message #498722 is a reply to message #498718] Thu, 10 March 2011 21:36 Go to previous messageGo to next message
demsaoroi88
Messages: 2
Registered: March 2011
Junior Member
I was embarrassed when watching both Dev and Live data, they are identical as you said. This problem has been researching and I do not know how to explain. Can you share with me some things not. This is nothing more wonderful. Thanks!
Re: Oracle character set? [message #498780 is a reply to message #498722] Fri, 11 March 2011 02:10 Go to previous message
antenc
Messages: 13
Registered: September 2009
Location: UK
Junior Member
I'm quite confused now.

PARAMETER	VALUE

NLS_LANGUAGE	AMERICAN
NLS_TERRITORY	AMERICA
NLS_CURRENCY	$
NLS_ISO_CURRENCY	AMERICA
NLS_NUMERIC_CHARACTERS	.,
NLS_CALENDAR	GREGORIAN
NLS_DATE_FORMAT	DD-MON-RR
NLS_DATE_LANGUAGE	AMERICAN
NLS_CHARACTERSET	WE8ISO8859P1
NLS_SORT	BINARY
NLS_TIME_FORMAT	HH.MI.SSXFF AM
NLS_TIMESTAMP_FORMAT	DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT	HH.MI.SSXFF AM TZR
NLS_TIMESTAMP_TZ_FORMAT	DD-MON-RR HH.MI.SSXFF AM TZR
NLS_DUAL_CURRENCY	$
NLS_NCHAR_CHARACTERSET	AL16UTF16
NLS_COMP	BINARY
NLS_LENGTH_SEMANTICS	BYTE
NLS_NCHAR_CONV_EXCP	FALSE


Both of the databases have the same NLS settings above, but when we write a £ to one of the tables from outside of the database i.e. on another machine, one replaces it with ??? (not correct) and the other ¿.

Cheers,

Carl
Previous Topic: Login problem
Next Topic: Oracle Standard Edition and CPU Socket
Goto Forum:
  


Current Time: Wed Dec 08 20:32:18 CST 2021