case insensitive search with postgresql

Scriptcase 8 Discussion
#1

Can anybody confirm if it works?

The only way I’m able to perform a case insensitive quicksearch in a grid with a postgresql connection is by using in the database CITEXT fields only instead of CHAR (CITEXT is a case insensitive field type managed by postgresql itself)

This regardless of the SC setting: SQL\Case Sensitive\Yes No.

#2

hi roby, this is the first time i see someone using postgresql which i suspect you see many people using it here… either try it yourself or send directly to SC, anyway they will reply you back in 2016 or Xmas 2015, good luck.

#3

No, it does not work