Skip to Main Content

Database Software

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!

Problem with characterset

ngac_ukMar 5 2012 — edited Mar 6 2012
We have a strange issue whereby when we have a (GBP POUND) sign '£' in the database it is showing as a '#' on various programs.

for example.

We Run Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit

If we run it in sql the field shows as # on db server.
If I run in SQL DEVELOPER it shows as £ on client.
If I run in SQL via forms/reports server it shows as £.
If we run via crystal reports it shows as # on one table and £ on another even though they have the same ascii value.

Can someone point me in right directions as alot of googleing turns up alot of NLS information but most of the Oracle ones I find the links are dead
select * from v$nls_parameters; returns on server:
NLS_LANGUAGE                                                     ENGLISH
NLS_TERRITORY                                                    UNITED KINGDOM
NLS_CURRENCY                                                     #
NLS_ISO_CURRENCY                                                 UNITED KINGDOM
NLS_NUMERIC_CHARACTERS                                           .,
NLS_CALENDAR                                                     GREGORIAN
NLS_DATE_FORMAT                                                  DD-MON-RR
NLS_DATE_LANGUAGE                                                ENGLISH
NLS_CHARACTERSET                                                 WE8MSWIN1252
NLS_SORT                                                         BINARY
NLS_TIME_FORMAT                                                  HH24.MI.SSXFF

PARAMETER                                                        VALUE
---------------------------------------------------------------- ---------------------------------------
NLS_TIMESTAMP_FORMAT                                             DD-MON-RR HH24.MI.SSXFF
NLS_TIME_TZ_FORMAT                                               HH24.MI.SSXFF TZR
NLS_TIMESTAMP_TZ_FORMAT                                          DD-MON-RR HH24.MI.SSXFF TZR
NLS_DUAL_CURRENCY                                                ?
NLS_NCHAR_CHARACTERSET                                           AL16UTF16
NLS_COMP                                                         BINARY
NLS_LENGTH_SEMANTICS                                             BYTE
NLS_NCHAR_CONV_EXCP                                              FALSE
On local PC
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                                                 WE8MSWIN1252
NLS_SORT                                                         BINARY
NLS_TIME_FORMAT                                                  HH.MI.SSXFF AM

PARAMETER                                                        VALUE
---------------------------------------------------------------- -----------------------------------
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_NCHAR_CHARACTERSET                                           AL16UTF16
NLS_COMP                                                         BINARY
NLS_LENGTH_SEMANTICS                                             BYTE
NLS_NCHAR_CONV_EXCP                                              FALSE
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 3 2012
Added on Mar 5 2012
7 comments
748 views