Skip site navigation (1) Skip section navigation (2)

odbc and bit-field

From: Jussi Jaaskelainen <jussi(dot)jaaskelainen(at)audioriders(dot)fi>
To: pgsql-odbc(at)postgresql(dot)org
Subject: odbc and bit-field
Date: 2001-07-30 09:34:25
Message-ID: 3B652A21.60812A16@audioriders.fi (view raw or flat)
Thread:
Lists: 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(dot)jaaskelainen(at)audioriders(dot)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

Responses

pgsql-odbc by date

Next:From: JosephDate: 2001-07-30 11:06:44
Subject: S1002: Invalid column number in ColAttributes
Previous:From: Henshall, Stuart - WCPDate: 2001-07-30 08:34:37
Subject: RE: A problem with the nextval('') function

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group