[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 09:38:16.000000000 -0500
+++ shadow/73159.tmp.3377	2005-03-16 09:59:09.000000000 -0500
@@ -102,6 +102,34 @@
 
 
 ------- Additional Comments From timo-mono@pokorra.de  2005-03-16 09:38 -------
 Created an attachment (id=14690)
 Progress ODBC trace log
 
+
+------- Additional Comments From timo-mono@pokorra.de  2005-03-16 09:59 -------
+I had another quick look, and I have to correct myself:
+The Numeric Value from PostgreSQL should be accessible as System.Double.
+That is at least what I get from executing:
+IDataReader schemareader =
+dbcmd.ExecuteReader(CommandBehavior.SchemaOnly);
+DataTable schema = schemareader.GetSchemaTable();
+DataRow[] currRows = schema.Select(null, null,
+DataViewRowState.CurrentRows);
+
+and then checking the DataType column;
+
+The DataType column has these values:
+postgresql: 
+a_ledger_number_i		System.Int32
+p_partner_key_n			System.Double
+a_ledger_status_l		System.Char
+a_base_currency_c		System.String
+
+Progress:
+a_ledger_number_i		System.Int32
+p_partner_key_n			System.Decimal	
+a_ledger_status_l		System.Boolean	
+a_base_currency_c		System.String
+
+If the values would be returned like advertised by this, that would be
+great!