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