[Mono-bugs] [Bug 73159][Nor] Changed - ODBC type SQL_WVARCHAR is not supported

[bugzilla-daemon@bugzilla.ximian.com]

Please do not reply to this email- if you want to comment on the bug, go to the
URL shown below and enter your comments there.

Changed by timo-mono@pokorra.de.

http://bugzilla.ximian.com/show_bug.cgi?id=73159

--- shadow/73159	2005-03-16 05:46:36.000000000 -0500
+++ shadow/73159.tmp.3030	2005-03-16 09:36:38.000000000 -0500
@@ -60,6 +60,38 @@
 can you check this with the svn 1.1. branch? a fix for proper
 conversion  between odbctype and sql types have been put recently.
 
 anyway, i checked with linux postgres. the driver gives a SQL_TYPE of
 12 (varchar). not wvarchar. can you send the trace log file, by
 enabling odbc tracing.
+
+------- Additional Comments From timo-mono@pokorra.de  2005-03-16 09:36 -------
+Thanks very much for looking into this!
+I have downloaded the latest sources, and it looks much better!
+As I see WVarChar is now automatically mapped to NVarChar, that is
+fine for me.
+
+Below are my results, running tests with PostgreSQL and Progress.
+As you see, Decimal works fine.
+But Numeric is returned as a string, I would expect it as a
+System.Decimal.
+Bit is also returned as a string, should that be mapped to System.Bool?
+
+Testing Postgresql
+col.OdbcType in OdbcDataReader.GetValue: a_ledger_number_i Int
+reader[].GetType: System.Int32
+col.OdbcType in OdbcDataReader.GetValue: p_partner_key_n Numeric
+reader[].GetType: System.String
+col.OdbcType in OdbcDataReader.GetValue: a_ledger_status_l Char
+reader[].GetType: System.String 
+col.OdbcType in OdbcDataReader.GetValue: a_base_currency_c NVarChar
+reader[].GetType: System.String 
+
+Testing Progress
+col.OdbcType in OdbcDataReader.GetValue: a_ledger_number_i Int
+reader[].GetType: System.Int32 
+col.OdbcType in OdbcDataReader.GetValue: p_partner_key_n Decimal
+reader[].GetType: System.Decimal 
+col.OdbcType in OdbcDataReader.GetValue: a_ledger_status_l Bit
+reader[].GetType: System.String 
+col.OdbcType in OdbcDataReader.GetValue: a_base_currency_c VarChar
+reader[].GetType: System.String