[Mono-bugs] [Bug 337624] New: System.Data.OracleClient: special chars (german) mapped as ? using mod_mono, apache2, oracle 9i/10g

[bugzilla_noreply at novell.com]

https://bugzilla.novell.com/show_bug.cgi?id=337624#c321993

           Summary: System.Data.OracleClient: special chars (german) mapped
                    as ? using mod_mono, apache2, oracle 9i/10g
           Product: Mono: Class Libraries
           Version: 1.2
          Platform: x86
        OS/Version: SuSE Linux 10.1
            Status: NEW
          Keywords: easy_fix, German
          Severity: Major
          Priority: P5 - None
         Component: Sys.Data
        AssignedTo: anagappan at novell.com
        ReportedBy: ghoki at hotmail.com
         QAContact: mono-bugs at ximian.com
          Found By: Development


Problem:
The issue is getting back "?" instead of "§ ß" when reading string data from
oracle database. also german chars "ä ö ü" will become "a o u" (or "?") when
using oracle connection by mono classes system.data.oracleclient.

Actual results: ?, a, u, o
Excpected results: ä (ae), ö (ue), ü (ue), ß (ss), § (paragraph) ...

Situation/reproduce:
The DB server is set up as NLS_CHARACTERSET: AL32UTF8 - what is recommended for
the german language support. On client side the configuration is setting the
client oracle parameter per user .profile, sysconfig for apache2 and setting
PassEnv in vhost.config for NLS parameters.
Reading or saving per system.data.oracleclient (oraclecommand ..) will cause
the actual result of "?" chars. 

Additional:
* A similar bug was reportet before: #321993 
* From what I know oracle replaces unknown chars to "?" while converting from
one charset to another. 
* Same code runs on MS ASP.NET independent on the oralce client NLS settings.
These can be set to the same as the server or to german. 
* Using mono 1.2.5.1


-- 
Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the QA contact for the bug.