Hello,
I have database as Oracle and development is in asp.net. Data stored is as, Förderer, Jörg etc.
Everything works fine on my local environment, where i can fetch the records having German characters, and i can display it on users browser.
However, when i deploy the solution on client machine, problem starts. When i fetch data from Oracle db. and fill a drop down or display it on label, it just does not show correct data. For e.g., Förderer gets converted to Forderer Jörg gets converted to Jorg ....
However, when i simply Response.Write("Förderer"), browser display it correctly. This means, that what i set in web.config works,
But, when it fetches information from db. , it does not display correctly. Then, i tried one more solution, to just avoid any direct table access. For that , i simply created TableAdapter, with command text like this,
Dim sQuery As String = "" sQuery = "SELECT 'Förderer' FROM DUAL"
Now, when i fetch information from dataset, that i filled with above command, it again does not display correct data, but converted "Forderer".
I appreciate any suggestion/help toward this.
-Divyesh