Case sensitivity

From: "Robert Hurst" <r_hurst(at)butler(dot)org>
To: <pgsql-odbc(at)postgresql(dot)org>
Subject: Case sensitivity
Date: 2001-05-08 22:41:10
Message-ID: NCBBIADNILACFKOJEIILKECKFHAA.r_hurst@butler.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

A suggestion for a feature to add to your already wonderful ODBC capability.
Could you add a boolean option that enables/disables case sensitivity with
ODBC calls? Consider this example, a Delphi client sends:

select * from logins where "Logins"."Login"='rhurst'

I know it looks ridiculous. This currently has the ill effect of forcing
pgsql to look for the table 'logins' (case sensitive) when only 'Logins'
exist! Wouldn't it be nice if I could set an ignore-case flag for ODBC?

Robert Hurst, I.S. Director
Butler Hospital · 345 Blackstone Boulevard · Providence, RI 02906
Voice: (401) 455-6262 · Pager: (401) 460-4594
A Care New England hospital, http://www.carenewengland.org
"Any technology distinguishable from magic is insufficiently advanced."

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Hiroshi Inoue 2001-05-09 01:11:50 Re: Re: [INTERFACES] Postgres odbc driver bug
Previous Message Cedar Cox 2001-05-08 22:07:31 Re: encrypt odbc transactions?