We want to inspire you for our UCC solution! To do this, we use cookies to provide you with an optimal and personalised website experience. Clicking on "Accept all" allows us to process this data and share it with third-party providers in accordance with our privacy policy (linked). Here you can also adjust the cookie settings at any time.
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.