Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2009
    Posts
    1

    Unanswered: japanese characters in the query fecthing no rows

    hi gurus,
    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.

    Thanks,
    Venkatesh

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    NLS_LANG=Japanese_Japan.JA16SJIS

    might need to be exported or modified depending upon actual client OS
    You 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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •