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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs pgsql-general pgsql-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
--------------------------------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | jose soares | 1999-09-30 12:47:47 | Re: [GENERAL] ODBC-client->Linux-server: datatype boolean not recognized? |
Previous Message | Mark Dalphin | 1999-09-29 19:09:34 | Problem with pg_dump and functions |
From | Date | Subject | |
---|---|---|---|
Next Message | jose soares | 1999-09-30 12:47:47 | Re: [GENERAL] ODBC-client->Linux-server: datatype boolean not recognized? |
Previous Message | Moray McConnachie | 1999-09-30 09:05:08 | Re: [GENERAL] Anyone doing a native NT port? |
From | Date | Subject | |
---|---|---|---|
Next Message | Paul Sorenson | 1999-09-30 11:23:32 | subscribe |
Previous Message | J. Carlos Muro | 1999-09-30 10:31:13 | Questions connecting to PostgreSQL. |