Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Issue with mu symbol (µ) when displayed through forms

tony.gMar 20 2014 — edited Mar 21 2014

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

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 18 2014

Added on Mar 20 2014

#forms, #moved-from-devops

3 comments

1,060 views