Unable to insert Swedish Characters
We have a problem inserting Swedish characters into Oracle DB though our application. Our application on Solaris makes use of Oracle client libraries to establish communication with Db server.
When the application receives swedish characters it fails to propagate them with the error
ORA-01756: quoted string not properly terminated
The query fired was
select FNAME from SYSTEM.MDSTAB where FNAME='å'
when I tried same thing using SQLPLus(Solaris) it works fine.
NLS_LANG environment variable: 'American_America.AL32UTF8'
Locale 'ISO-8859-1' maps to character set 'ISO-8859-1
Any help would be highly appreciated