3 Replies Latest reply: Mar 21, 2014 4:51 AM by tony.g RSS

    Issue with mu symbol (µ) when displayed through forms

    tony.g

      Hi

       

      I have this problem on forms 11.1.1.3 and also 11.1.2.1, the database in both cases is 11.2.0.2.

       

      Some data columns in the database have the mu symbol (µ) using it to show 'micro' for some units of measure, e.g. µg/l for microgram per litre.

       

      If you look with database tools, e.g. sqlplus or toad then you can see the µ symbol in the database column data. When this is displayed through the forms it is not displayed correctly and a ? is displayed instead.

       

      I'm guessing that this might be some configuration issue.  Anyone have any idea please?

       

      The database is Linux64 bit the character set is WE8ISO8859P1 .

       

      Here are all our NLS parameters:-

       

      PARAMETER VALUE

      NLS_LANGUAGE AMERICAN

      NLS_TERRITORY AMERICA

      NLS_CURRENCY $

      NLS_ISO_CURRENCY AMERICA

      NLS_NUMERIC_CHARACTERS .,

      NLS_CHARACTERSET WE8ISO8859P1

      NLS_CALENDAR GREGORIAN

      NLS_DATE_FORMAT DD-MON-RR

      NLS_DATE_LANGUAGE AMERICAN

      NLS_SORT BINARY

      NLS_TIME_FORMAT HH.MI.SSXFF AM

      NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM

      NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR

      NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR

      NLS_DUAL_CURRENCY $

      NLS_COMP BINARY

      NLS_LENGTH_SEMANTICS BYTE

      NLS_NCHAR_CONV_EXCP FALSE

      NLS_NCHAR_CHARACTERSET AL16UTF16

      NLS_RDBMS_VERSION 11.2.0.2.0

       

      rgds

      Tony