Results 1 to 7 of 7
  1. #1
    Join Date
    Apr 2008
    Posts
    24

    Unanswered: NLS_LANG: How to extract data in ENGLISH,CHINESE,JAPANESE from a table

    Hi All,

    I have a table having data in ENGLISH,CHINESE,KOREAN,JAPANESE languages. The Oracle Database is 10.2.0.4 and NLS_LANG:UTF8.

    When I use TOAD/PL-Sql Developer to run the select statement, it shows only the data in ENGLISH and rest is like ' ???????????? '.When I use Putty to run the select statement, it shows only the data in ENGLISH, rest is empty.

    How to find the data in respective LANGUAGES.

    Please suggest me.

    Cheers,
    gohappy

  2. #2
    Join Date
    Aug 2009
    Posts
    262
    I have never came across this problem ever before .
    just making a wild assumption , not better then yours .

    Not Displaying of data in other languages is the issue of TOAD language support .
    "one cant have every thing in price of a one" you've bought and install your software in english version.

    i suggest you use Sql Developer , atleast it will support languages which are supported by your os .

    again language display is a front end tool issue

  3. #3
    Join Date
    Apr 2008
    Posts
    24
    I have the same problem in PL/SQL Developer. I tried in Putty also, but no result.

    Is there any setting in PL/SQL Devloper to resolve this issue?

    Cheers,
    gohappy

  4. #4
    Join Date
    Aug 2009
    Posts
    262
    NLS Database Parameters
    Parameter Value
    NLS_CALENDAR GREGORIAN
    NLS_CHARACTERSET WE8MSWIN1252
    NLS_COMP BINARY
    NLS_CURRENCY $
    NLS_DATE_FORMAT DD-MON-RR
    NLS_DATE_LANGUAGE AMERICAN
    NLS_DUAL_CURRENCY $
    NLS_ISO_CURRENCY AMERICA
    NLS_LANGUAGE AMERICAN


    this is from pl/sql developer . seems more dependent on database parameters.

    try changing the nls parameter of db and check in pl/sql developer.

    (its in reports menu)

  5. #5
    Join Date
    Apr 2008
    Posts
    24
    Thanks mishaalsy for your response....

    These are my settings in Database

    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 UTF8
    NLS_SORT BINARY
    NLS_TIME_FORMAT HH.MI.SSXF

    Oracle suggest to change NLS_LANG=UTF8 in regedit (windows) to make the proper laguage conversion. Let me try and will update the result .

    Cheers,
    gohappy

  6. #6
    Join Date
    Aug 2009
    Posts
    262
    http://www.oracle.com/technology/tech/globalization/htdocs/nls_lang%20faq.htm#_Toc110410543

    i've found this oracle documentation regarding nls .
    i hope it will benefit you

  7. #7
    Join Date
    Aug 2009
    Posts
    262
    Also if you are on 11g . (since i dont know your db version , i i should have been told) .
    or 10g even .

    start "Local Builder " from start menu ->oracle . there you can set up your nls by FILE->NEW->language

Posting Permissions

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