I'm writing an application that should work with PostgreSQL server on
Linux and ODBC-MS Access on Windows.
I'm using the TclODBC package that works just fine.
Under Windows, with ODBC->MS Access , the select LIKE 'john%' works case
insensitive!
Under Linux with PostgreSQL 6.5.2 , the LIKE clause is case sensitive!
Is there for PostgreSQL a modifier(parameter) that will make the LIKE
clause case insensitive ?
TIA,
Constantin Teodorescu
FLEX Consulting Braila, ROMANIA