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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-odbc by date

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