Help us to improve our website!

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.
Technically necessary cookies
Statistics
Comfort
Accept all
Save selection

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.