Lowercase folding - simple patch?

From: agnewtj(at)netscape(dot)net
To: pgsql-odbc(at)postgresql(dot)org
Subject: Lowercase folding - simple patch?
Date: 2005-07-26 19:29:29
Message-ID: 32C16340.37C09F61.001D55E8@netscape.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc


Hello,

We have a large database with camel case names for schemas, tables, columns, etc. I'm able to connect via ODBC with MS Access, but not with Excel (MSQuery). The names are not quoted and lowercase folding kicks in - so all tables are 'not found'. If I manually edit the MSQuery sql and double-quote all names, i can get the queries to work - but each and every query must be manually edited. Obviously unworkable.

Is it possible for the odbc driver to return schema, table and column names to MSQuery in double-quoted form so queries are built correctly? Alternatively, could the odbc driver insert double-quotes on-the-fly once it sees uppercase characters in the names?

This would help us immensely!!!

Thanks in advance,
Tom Agnew

__________________________________________________________________
Switch to Netscape Internet Service.
As low as $9.95 a month -- Sign up today at http://isp.netscape.com/register

Netscape. Just the Net You Need.

New! Netscape Toolbar for Internet Explorer
Search from anywhere on the Web and block those annoying pop-ups.
Download now at http://channels.netscape.com/ns/search/install.jsp

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Merlin Moncure 2005-07-26 19:51:02 Re: Lowercase folding - simple patch?
Previous Message Bob Caryl 2005-07-26 18:05:53 Re: Ok... I got most of it working but . . .