From: | Byron Nikolaidis <byronn(at)insightdist(dot)com> |
---|---|
To: | "Christopher R(dot) Jones" <cj(at)interlog(dot)com> |
Cc: | PostgreSQL Interfaces <pgsql-interfaces(at)postgreSQL(dot)org> |
Subject: | Re: [INTERFACES] postdrv ODBC driver problems |
Date: | 1999-03-03 19:12:54 |
Message-ID: | 36DD89B6.975FCA41@insightdist.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces |
Christopher R. Jones wrote:
> >Yes, it is a known problem with mixed case. Some Microsoft apps don't
> >bother to use quotes around table/field names to preserve the case, I guess
> >cause they assume that every dbms works like Microsoft SQL server. MSAccess
> >however does always use quotes so mixed case names are no problem with
> >MSAccess.
> >
> >I'm not really sure how to proceed on this one. Maybe you could just use
> >all lower case names for now.
> >
> >It would seem to me that if an identifier (table/field name) is not quoted
> >in an sql statement, then Postgres should not care about the case and match
> >on it. That to me seems like the correct approach.
> >
> >Any opinions?
> >
> >Byron
> I have always thought it strange that Access would allow field names with
> mixed case and spaces. I come from the Foxbase side and Visual Foxpro has
> maintained the tradition of lower case, no space field names. It
> simplifies things to stick to one naming convention that works for all
> databases.
MSAccess checks to see if the driver supports quoted identifiers. If it does, it
allows the spaces and mixed case in field/table names. If it doesn't, it does
not allow those things.
Byron
From | Date | Subject | |
---|---|---|---|
Next Message | Matthew Hagerty | 1999-03-03 21:04:41 | Postgres to MS-Word? (Kind of off topic) |
Previous Message | Christopher R. Jones | 1999-03-03 18:58:07 | Re: [INTERFACES] postdrv ODBC driver problems |