SQL_C_CHAR & SQL_VARBINARY - Mailing list pgsql-odbc

From Han
Subject SQL_C_CHAR & SQL_VARBINARY
Date
Msg-id 20021126042218.85AC7474E44@postgresql.org
Whole thread Raw
List pgsql-odbc
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




pgsql-odbc by date:

Previous
From: Hiroshi Inoue
Date:
Subject: Re: inserting blob data
Next
From: Hiroshi Inoue
Date:
Subject: Re: Bug #2 in latest ODBC driver (07.02.0004)