Hi All,

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