I'm trying to insert a fixed sized string field into postgres 8.4.4 using dotConnect 4.95.146. In my case the field in the database is of type char(6).
I'm using a function (stored procedure) to insert the data. This function is called by the .net code using a parameter of type DbType.StringFixedLength.
When I invoke the function in postgres directly, the data is inserted in the table as expected:
Code: Select all
Any help would be greatly appreciated.
P.S. I'm using a protocol v2 connection.
 Even when I set the parameter.Size to 6 manually, I still get the same result.