[GENERAL] Case sensitivity

2001-08-13 Thread Scott Gilbert
We intend to move from M$ Access to PostgreSQL, however, much of our legacy code operates under the assumption that string or text comparisons are case insensitive whereas postgres is case sensitive. This issue extends to SQL Select statements as well as straight comparison (i.e. in addition to t

[GENERAL] PostgresSQL 7.1 and ODBC/MSAccess

2001-05-21 Thread Scott Gilbert
I have a problem with PostgresSQL 7.1 and Micro$oft Windoze ODBC and MS Access 2000 which I am hoping someone here might be able to help me with. When I try to link MS Access to a PostgresSQL 7.1 table, Access is unable to see any of the tables in the database so I cannot select a table to link.