Message-ID: <004201bf85bc$3d2c9120$0500020a@wilsoft.nl>
From: "W. van den Akker" <wvdakker@wilsoft.nl>
To: "Aage J. Skjolingstad" <aages@aajs.com>
Cc: <pgsql-interfaces@postgresql.org>
References: <001a01bf85b5$cd5d45c0$0500020a@wilsoft.nl>
	<38C0D37F.E443558D@aajs.com>
Subject: Re: [INTERFACES] ODBC
Date: Sat, 4 Mar 2000 10:30:11 +0100
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

Initally I've done that too, but I have to convert several databases.

PostgreSQL does support longvar fields for string longer that 255, does it??

Willem

----- Original Message -----
From: Aage J. Skjolingstad <aages@aajs.com>
To: W. van den Akker <wvdakker@wilsoft.nl>
Sent: Saturday, March 04, 2000 10:12 AM
Subject: Re: [INTERFACES] ODBC


> Hi,
>
> I had a similar problem and chose to change all my capital letters to
> lower case prior to converting from Access, ---- It finally made my
> life easier after doing so.
> (and field sizes max 255)
>
> Good Luck
>
> Aage
>
> > "W. van den Akker" wrote:
> >
> > Hi,
> >
> > I've some (only one actually) problems with the conversion
> > from Access to PostgreSQL. The table and columnnames
> > of the Access database do have sometimes capitals (ThisTable,
> > ThisColumn).
> > If I convert this table or row, the table and row are created but I
> > cann't
> > access them. It lookes like the postgress engine converts
> > automaticly all
> > names to lowercase. If a table is created the conversion to
> > lowercases
> > doesn't occur.
> >
> > Am I doing something wrong, or need the postgress ODBC-driver be
> > changed?
> >
> > TIA
> >
> > Willem
>