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

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

From: Jelle Ruttenberg <ruttenberg(at)neroc(dot)nl>
To: "postgresql-interfaces" <pgsql-interfaces(at)postgresql(dot)org>
Cc: "postgresql-general" <pgsql-general(at)postgresql(dot)org>, "postgresql-bugs" <pgsql-bugs(at)postgresql(dot)org>
Subject: ODBC-client->Linux-server: datatype boolean not recognized?
Date: 1999-09-30 10:39:13
Message-ID: 199909301033.MAA06992@mail.neroc.nl (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-generalpgsql-interfaces
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 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

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
--------------------------------------------------------------


Responses

pgsql-bugs by date

Next:From: jose soaresDate: 1999-09-30 12:47:47
Subject: Re: [GENERAL] ODBC-client->Linux-server: datatype boolean not recognized?
Previous:From: Mark DalphinDate: 1999-09-29 19:09:34
Subject: Problem with pg_dump and functions

pgsql-interfaces by date

Next:From: Paul SorensonDate: 1999-09-30 11:23:32
Subject: subscribe
Previous:From: J. Carlos MuroDate: 1999-09-30 10:31:13
Subject: Questions connecting to PostgreSQL.

pgsql-general by date

Next:From: jose soaresDate: 1999-09-30 12:47:47
Subject: Re: [GENERAL] ODBC-client->Linux-server: datatype boolean not recognized?
Previous:From: Moray McConnachieDate: 1999-09-30 09:05:08
Subject: Re: [GENERAL] Anyone doing a native NT port?

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