National Character Set

[KenCunningham]

Hi folks. Hopefully a quickie. Does anyone have an example National Character Set for the UK? I'm having problems because one of our apps won't print pound (£) signs and I'm hoping that creating a new database with the appropriate NLS setting and then importing the data might resolve the issue.

Any experiences/gotchas with this approach would also be appreciated. TIA.

I want to be good, is that not enough?

 

[kutz13]

Not aware of any NLS_LANGUAGE support specifically for UK, 'ENGLISH' is the best you'll get.
However, if you set NLS_TERRITORY to 'UNITED KINGDOM' you also implicitly define the following parameters:
NLS_NUMERIC_CHARACTERS,
NLS_CURRENCY,
NLS_ISO_CURRENCY,
NLS_DATE_FORMAT
NLS_MONETARY_CHARACTERS,
NLS_CREDIT,
NLS_DEBIT
If necessary these can also be explicitly defined, e.g. NLS_NUMERIC_CHARACTERS = ",.