| Oracle character set? [message #498557] |
Thu, 10 March 2011 04:46  |
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 #498566 is a reply to message #498561] |
Thu, 10 March 2011 05:08  |
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 #498780 is a reply to message #498722] |
Fri, 11 March 2011 02:10 |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
