Oracle .NET Stored Procedure, Parameters and characterset
Hi,
we have an Oralce .Net Stored Procedure and this is working fine, with the exception that when we pass parameters which contain special (German) characters (ÄÖÜ ß) than we don't get these values within the procedure. There we get an AOU ?.
Database settings are for NLS_LANGUAGE GERMAN, NLS_TERRITORY GERMAN, NLS_CHARACTERSET WE8ISO8859P1
Same as for client settings.
we have an Oracle 10gR2, using Visual Studio 2005
Are there any other settings we have to set?
Thanks for your help!
Raphael