Received: from mail.neroc.nl (mail.neroc.nl [212.52.0.12])
	by hub.org (8.9.3/8.9.3) with ESMTP id KAA75612;
	Wed, 6 Oct 1999 10:27:03 -0400 (EDT)
	(envelope-from ruttenberg@mail.neroc.nl)
Received: from [212.52.7.230] (hermes.ehv.neroc.nl [212.52.7.230])
	by mail.neroc.nl (8.9.3/8.9.3) with SMTP id QAA01813;
	Wed, 6 Oct 1999 16:22:12 +0200
Message-Id: <199910061422.QAA01813@mail.neroc.nl>
Subject: Q: ODBC- and PostgreSQL-datatypes difference?
Date: Wed, 6 Oct 1999 16:28:23 +0200
x-sender: ruttenberg@mail.neroc.nl
x-mailer: Claris Emailer 2.0v3, January 22, 1998
From: Jelle Ruttenberg <ruttenberg@neroc.nl>
To: "postgresql-interfaces" <pgsql-interfaces@postgresql.org>,
	"dbi-users" <dbi-users@isc.org>,
	"postgresql-interfaces" <pgsql-interfaces@postgresql.org>,
	"postgresql-general" <pgsql-general@postgresql.org>,
	"postgresql-interfaces" <pgsql-interfaces@postgresql.org>
cc: "postgresql-general" <pgsql-general@postgresql.org>
Mime-Version: 1.0
Content-Type: text/plain; charset="US-ASCII"

Hi all,

I've posted some time ago about my experiences concerning connecting from 
a Mac-client via OpenLink to a Linux-server with PostgreSQL. Now I'm able 
to connect, but the datatypes ODBC gives back to the client aren't all as 
I supposed they would be.

A small table with some datatypes/results:

PostgreSQL-    Length    ODBC-datatype
datatype
bool			         1        SQL_CHAR
date				       10		      SQL_CHAR
time				       16		      SQL_CHAR
timestamp			   30		      SQL_CHAR
int2				       2		       SQL_SMALLINT
int4				       4		       SQL_INTEGER
int8				       8		       SQL_CHAR
float4				     4		       SQL_REAL
float8				     8		       SQL_DOUBLE
char				       16		      SQL_CHAR
varchar				    255		     SQL_VARCHAR
text				       8000      SQL_LONGVARCHAR

Is this normal behaviour, or is this due to the OpenLink-software which 
has a database-agent highly possible based on Postgres95, or is this 
something different?

I suppose PostgreSQL 'talks' with ODBC-clients via an embedded 
ODBC-interface. If so, how can I test this interface and check if there 
are some problems?

PostgreSQL: 6.5.2
Linux: RH 6.0

Thanks,
Jelle.

--------------------------------------------------------------
                   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@neroc.nl
--------------------------------------------------------------