Re: Access migration woes.

Tim Uckun wrote:

> I was really hoping to avoid redoing every single query in my
> application (over a thousand!) either by setting some option in the ODBC
> driver or the back end database. Somebody suggested I overload the "="
> operator in postgres but I am not much of a C++ programmer. The other
> suggestion was to use regexp searches which would also force me to redo
> all my queries. Is SQL server the only database that does case
> insensitive matches?

Are you sure it does? And what if you want the search to be case sensitive ? After all, 'A' is different from 'a'.

In fact, I would imagine that the SQL "standard" would require matching to be case sensitive.

There are options available to you, but at present I can't see any that do not involve substantial work. Pity!

Rudy Received on Wed Mar 22 2000 - 00:00:00 CST