Hi guys.
We have this problem - our application uses special characters sometimes, like german umlauts. We read those from an excel spreadsheet, and it is all fine while debugging. However, after commiting the strings to the database, they loose the national information, let's call it this way. How can I configure stuff so that it works fine?
Issuing this against the db:
Code:
select value from nls_database_parameters where parameter = 'NLS_CHARACTERSET';
select value from nls_database_parameters where parameter = 'NLS_NCHAR_CHARACTERSET';
gives back:
Code:
WE8ISO8859P1 and AL16UTF16
In the database schema, we use varchar exclusively, not nvarchar (which uses utf16), so i changed a column to test if that works, but didn't, again, the national characters were replaced by others.
How can we overcome this? Has anyone had such problems? How should we go about this?
Thanks.
Login
FAQ
Search