Skip site navigation (1) Skip section navigation (2)

Re: Lowercase folding - simple patch?

From: Eric E <whalesuit(at)bonbon(dot)net>
To: agnewtj(at)netscape(dot)net
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: Lowercase folding - simple patch?
Date: 2005-07-27 21:25:44
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-odbc
Hi Tom,
    I encountered this problem as well, and I agree that it's rather a 
nuisance.  You've probably thought of this, but if you are just using a 
limited set of tables in Excel (like for pivot tables), you might just 
try wrapping them into a view with lowercase names - this is what I 
did.  It might also be worth dropping a line to Microsoft about this 
problem, as they have evidently made this work in Access, and I believe 
quoting for mixed case is part of SQL92.

All that said, I definitely second your suggestion.



agnewtj(at)netscape(dot)net wrote:

>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
>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
>---------------------------(end of broadcast)---------------------------
>TIP 6: explain analyze is your friend

In response to

pgsql-odbc by date

Next:From: Mie KieDate: 2005-07-28 12:10:28
Subject: odbc win.xp and mandrake 10
Previous:From: Pailloncy Jean-GerardDate: 2005-07-27 16:46:51
Subject: iODBC & Mac OS

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group