Hi,
It seems that convertion between SQL_C_CHAR and SQL_VARBINARY in psqlodbc is not standard. For example,
SQL_C_CHAR('01')should be explaned as hexdecimal and be converted to SQL_VARBINARY(00000001), but psqlodbc deals it the
sameas SQL_CHAR('01')--there are 2 ASCII chars inserted into the database. And vice versa, when retrived form
database,SQL_VARBINAY('01') was convered to char string '01', but it should have been it's hex form.
If I was right, I hope a fix to it soon :)
Thanks!!!
Han
zhouhanok@vip.sina.com
2002-11-26