[Mono-bugs] [Bug 364430] New: ODBC: Command fails to use a UNICODE string parameter

bugzilla_noreply at novell.com bugzilla_noreply at novell.com
Sun Feb 24 11:08:22 EST 2008


           Summary: ODBC: Command fails to use a UNICODE string parameter
           Product: Mono: Class Libraries
           Version: 1.2.6
          Platform: i686
        OS/Version: Windows XP
            Status: NEW
          Severity: Major
          Priority: P5 - None
         Component: Sys.Data
        AssignedTo: bnc-blr-team-mono at forge.provo.novell.com
        ReportedBy: mjscod at gmx.de
         QAContact: mono-bugs at lists.ximian.com
          Found By: Customer

System.Data.Odbc.OdbcCommand fails using a UNICODE string parameter. Example:

1. Create a table (test) with two columns (id integer, text nvarchar)
2. create an OdbcCommand with text: INSERT INTO test ("id","text") VALUES (?,?)
3. Add Parameters "id" with value 1 (DbType.Int32), "text" with value
"aфbиcсdвeуfа" (DbType.String)
4. Execute

Now you should check the values:

1. SELECT LENGTH("text") FROM "test" WHERE "id"=1
-> Returned value is 12 but the string should be longer
2. SELECT "text" FROM "test" WHERE "id"=1
-> Shows "??????" in the console. I understand that the unicode characters are
shown as "?" due to a limitation of the Windows console but where are the
characters "a".."f"?

I use the developer version of Sybase SQL Anywhere 10 + latest fixes.


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

More information about the mono-bugs mailing list