Search code examples
sqlconfigurationfirebirdcase-sensitive

Firebird configuration - turn case-sensitivity off

I'm looking to perform case-insensitive search in a Firebird database, without modifying actual queries. In other words, I'd like all my existing "SELECT/WHERE/LIKE" statements to retrieve BOB, Bob, and bob. Does Firebird configuration allow to modify this behavior?

Solution

  • Eventually I went with creating shadow columns containing lower-cased versions of required fields.