odbc and bit-field - Mailing list pgsql-odbc

From Jussi Jaaskelainen
Subject odbc and bit-field
Date
Msg-id 3B652A21.60812A16@audioriders.fi
Whole thread Raw
List pgsql-odbc
Hi!
Is this bug or is this "bug"...
I have table with field type 'bit'  acting as "boolean (true/false)" but
thru ODBC driver (in Win-NT 4) it's reported to be "VARCHAR [254]", so
it cannot be set to True or False (or 1 or 0)

Problem araised when I tried to move data from MSSQL 7 server to
Postgresql table using datatransform-services and odbc-drivers

Postgresql server is Linux 7.0.3 at SuSE 7.0
Odbc-driver is 7.01.00.06  date 06/03/01

--
Jussi Jääskeläinen        Email:  jussi.jaaskelainen@audioriders.fi
Audio Riders Oy           Tel:    +358-9-276 6820  direct: +358-9-276
68212
Järvihaantie 4            Mobile: +358-40-554 3689
FIN-01800 KLAUKKALA       Fax:    +358-9-879 8045
FINLAND                   WWW:    http://www.audioriders.fi

pgsql-odbc by date:

Previous
From: "Henshall, Stuart - WCP"
Date:
Subject: RE: A problem with the nextval('') function
Next
From: "Joseph"
Date:
Subject: S1002: Invalid column number in ColAttributes