Why is the search in PostgreSQL case sensitive?

The search in a connected PostgreSQL database is case sensitive. This means that the database gives results only if you searched with the corresponding upper and lower case letters.

To be able to search case insensitively, the ANSI ODBC driver must be used when connecting PostgreSQL via ODBC and the check mark at "Text as LongVarChar" must be removed.