Hi 

I am facing problem while inserting string 'CH-FERBÖX_A_'. The character 'Ö' is getting converted into 'O' after insertion.The string is being  converted into ' CH-FERBOX_A_' after insertion.When I fire same insert statment using  sql plus , replacement of character from  'Ö' to 'O' did not happen.I am using ASP.Net 1.1.

Actual String  : 'CH-FERBÖX_A_'

Value in DB : ' CH-FERBOX_A_' after insertion

does anyone know how to get around this problem ?

Thanks in advance

 A. Don't use the umlaut?

B. Can you use the html code (Ö) instead? 

Check out this link

http://builder.com.com/5100-6388-5319617.html

Hope it helps.

Thanks for quick reply.But even after using compose and unstr functions I could not able to insert character  Ö . Whenever I try to insert character from asp.net the character is being converted to O.

I tried inserting from a web app and the character was inserted correctly.

Imports System.Data.OracleClient

--------------

Dim cmd As New OracleCommand

.CommandText = "insert into assembly.production_goals" & vbNewLine & _

" (system, section, key, value)" & vbNewLine & _

"values" & vbNewLine & _

End With

Try

End Try

End Sub

----------------

Db record key value:

Ü, O¿ ö,  naïve,  café with résumé.

It is still not working for me.I am just wondering if it is something related  with my oracle character set settings.

By using compose and unistr I am not even able to insert values when I fired query directly from sqlDeveloper.

Thanks

Pankaj