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.

Subscribe to our Newsletter


Thank you for subscribing. To confirm your subscription, please click the link in your registration email.


An error occured. Please try again.

Cookies ermöglichen eine bestmögliche Darstellung unserer Dienste. Mit der Nutzung der Seiten von C4B Com For Business, erklären Sie sich damit einverstanden, dass wir Cookies verwenden. mehr Infos