British Pound Signs
I have rapidly pulling my hair out trying to get british pound signs to work in web forms.
Our database character set is US7ASCII and although I have seen various documents stating that this does not support pound signs, we never had any trouble saving and querying them in character mode.
In client server I found that to make it work I had to set NLS_LANG to AMERICAN_AMERICA.US7ASCII in the registry.
In web forms I have done the same NLS_LANG setting as an environment variable before starting the forms server. The forms are displaying pound signs correctly when queried from the database, or when typed in, but they are being saved as hash signs.
Has anyone any idea what is happening or how I can fix it ?