Database Administration (MOSC)

MOSC Banner

How to fix the Pound signs ('£') into the database?

edited Nov 4, 2009 4:22PM in Database Administration (MOSC) 6 commentsAnswered
This problem has been around for a number of years and we are now looking into a resolution.  The users have been entering pound signs ('£') into the database and these are being displayed back as upside down question marks.  The suggested resolution is to change the database to the 'WE8MSWIN1252' character set and change the NLS_LANG settings on the clients to 'English_United Kingdown.WE8MSWIN1252'.  Additionally, we would add the following to the database initialization file: nls_currency='£'
nls_language='English'
nls_territory='United Kingdom'
To achieve this we intend running the csscan utility with:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center