Message-ID: <38087083.6CC7A6AC@deis.unibo.it>
Date: Sat, 16 Oct 1999 14:33:07 +0200
From: Cristiano Verondini <cverondini@deis.unibo.it>
Organization: =?iso-8859-1?Q?Universit=E0?= degli Studi di Bologna - Italy
MIME-Version: 1.0
To: pgsql-interfaces@postgreSQL.org
CC: Israel Zavalza Bahena <izavalza@hotmail.com>
Subject: Re: [INTERFACES] Postgres ODBC and PostgreSQL 6.5.2
References: <19991012202204.17440.qmail@hotmail.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Content-Transfer-Encoding: 7bit

> >       I have installed PostgreSQL 6.5.2 on my Linux box, and ODBC drivers for
> >Windows from http://www.insightdist.com/psqlodbc.
> >
> >       All seemed to work fine, that is I can connect tables using MsAccess,
> >and browse throught data.
> >
> >       But when I examined closer, I found some data is missing. This i s the
> >data structure I use:
> >
> >CREATE TABLE WWork (
> >   IDWork int4,
> >   titolo CHAR(1000),
> >   autori CHAR(1000),
> >   affiliazione CHAR(1000),
> >   sommario varchar(1024),
> >   IDpertinenza int4,
> >   autoreRiferimento CHAR(100),
> >   emailRiferimento CHAR(100),
> >   file1 CHAR(50),
> >   file2 CHAR(50),
> >   file3 CHAR(50),
> >   file4 CHAR(50),
> >   file5 CHAR(50),
> >   demo INT4
> >) \g
> >
> >       Some of the data are missing (but I can see them using pgaccess on
> >linux), as titolo, autori, ... and some is truncated, such as sommario.

Israel Zavalza Bahena wrote:

> In the ODBC Driver Advanced Options you can change the max size of data
> as much as 4096 bytes.
> 
> Check that. It should be the problem

	I rised the limits, but this doesn't solve my problem. I found data in
fields from Access is all of blank char (0x20) for field 'autori'.

	Any other idea?

		Cris


-- 
Cristiano Verondini
http://www.ing.unibo.it/~cverond