06-09-09, 02:49 #1Registered User
- Join Date
- Jun 2009
Unanswered: japanese characters in the query fecthing no rows
i have a query which contains japnese charactrers in the where condition, this query fecthing no data if fire this query is fired through sqlplus, but same query is fectching data through oracle sql developer.
problem is we have a cognos report with this filter and that is showing no data in the out put. cognos people said that for a report to show data in the output same query needs to fetch data in the sqlplus and they suggested to set nls_lang to JAPANESE_JAPAN.JA16SJIS both on server and client to show data in the report
we have oracle installed on linux machine. can any one say how to set nls_lang on linux server or how to make this query fetch data in sqlplus.
06-09-09, 11:41 #2Registered User
Provided Answers: 1
- Join Date
- Aug 2003
- Where the Surf Meets the Turf @Del Mar, CA
might need to be exported or modified depending upon actual client OSYou can lead some folks to knowledge, but you can not make them think.
The average person thinks he's above average!
For most folks, they don't know, what they don't know.
Good judgement comes from experience. Experience comes from bad judgement.