This discussion is archived
1 2 Previous Next 15 Replies Latest reply: Oct 10, 2012 4:02 AM by CInglez Go to original post RSS
  • 15. Re: Generic Currency Symbol
    CInglez Newbie
    Currently Being Moderated
    1) This result is from sqlplus, having set NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P15
    2) Yes, but in sqlplus, not in SqlDeveloper
    3) In SqlDeveloper, no change. I still don't know if it is affected by the NLS_LANG environment variable.
    4) Yes, both seem to give me the same results
    5) Yes. On sqlplus, chr(0164) returns ñ, chr(207) returns ¤ (correct). On SqlDeveloper, chr(0164) returns the Euro Symbol, chr(207) returns Ï.
1 2 Previous Next

Legend

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