ODBC-client->Linux-server: datatype boolean not recognized?

From: Jelle Ruttenberg <ruttenberg(at)neroc(dot)nl>
To: <pgsql-hackers(at)postgresql(dot)org>
Subject: ODBC-client->Linux-server: datatype boolean not recognized?
Date: 1999-09-30 14:46:16
Message-ID: 199909301440.QAA10002@mail.neroc.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hello all,

I posted the following also to pgsql-interfaces/general, but got no
workable solution (yet).

The ODBC client-application I'm developping will be able to run on Mac
and WIN/NT, uses booleans itself and has to be able to be a frontend for
a range of SQL-databases.

Thanks,
Jelle

vvvv MESSAGE vvvv

Hello all,

I'm trying to connect from a ODBC-client to PostgreSQL on a Linux-server.
All is going well, except that the ODBC-client seems not to recognize the
PostgreSQL boolean-datatype.

Is this really caused by PostgreSQL? If yes: is there a workaround, like
altering the datatypename 'bool' in the proper places (pg_type?)? If no:
then it is another problem and can somebody give a hint?

Thanks,
Jelle.

I tested and encountered it in the following testsituations:

Situation 1:
Client: Mac via OpenLink ODBC-Client
Server: Linux RH 6.0 via OpenLink Requestbroker
Result: it looks like PostgreSQL-boolean is converted to SQL_C_CHAR, the
datatype itself is called 'bool'

Situation 2:
Client: NT with psqlODBC
Server: same Linux
Result: in MS-Query:
- viewing the table-definitions, it comes with the message that it
doesn't recognize datatype 'bool'
- selecting values it looks like PostgreSQL-boolean is converted to a
numeric

PostgreSQL: 6.5.1

--------------------------------------------------------------
NEROC Publishing Solutions

Jelle Ruttenberg

De Run 1131, 5503 LB Veldhoven Phone : +31-(0)40-2586641
P.O.Box 133, 5500 AC Veldhoven Fax : +31-(0)40-2541893
The Netherlands E-mail : ruttenberg(at)neroc(dot)nl
--------------------------------------------------------------

Browse pgsql-hackers by date

  From Date Subject
Next Message Jan Wieck 1999-09-30 14:57:10 RI status report #3
Previous Message Tom Lane 1999-09-30 13:33:09