This discussion is archived
1 Reply Latest reply: May 2, 2013 3:22 PM by clcarter RSS

Problem with character set (ubuntu linux)

646357 Newbie
Currently Being Moderated
hello everyone.

I 'have already installed oracle-xe-universal_10.2.0.1-1.1_i386 in ubuntu.
The problem is that greek characters from the db appear like ??????.
How can i set the right nls_lang character set to solve the problem in ubuntu linux?


Thank you in advance!
  • 1. Re: Problem with character set (ubuntu linux)
    clcarter Expert
    Currently Being Moderated
    Character code point translation is in the realm of the client, try setting NLS_LANG environment variable.

    If your client programs handle UTF8, as do many linux utilities, that is the best choice, set your <language>_<locale>.<characterset>, i.e.

    export NLS_LANG=AMERICAN_AMERICA.AL32UTF8

    Or french_france, or german_germany ... depends on the locale you want to use. Try a `putty` session to the host, the terminal can be set for many different character sets, i.e. ISO8859-<n> a.k.a. the WE8<n> or Western European, UTF, etc. under Window/Translation.

    Try a few select ... from dual; statements in sqlplus with a literal, and different unicode values- the unistr() and dump() functions can come in quite handy.

    select unistr('\ac20 euro' ) from dual;
    ... € euro ...
    select dump( unistr('\ac20 euro' ) ) from dual;
    ... <ascii codes for the character values> ...
    select dump( unistr('\ac20 euro' ),16 ) from dual; -- this one for hex dump

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points