Re: [INTERFACES] Postgres ODBC and PostgreSQL 6.5.2

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