Case insensitive text queries?

Self-Host
1

Hey team - via the API, how do I enforce case-insensitive text queries? Is there a way to enable this, or is it an underlying datatype issue?

2

By default, we perform a case-insensitive search. To help you better, could you please provide more details?

  1. Are you using the cloud or self-hosted version?

  2. If you’re using the cloud version:

    • Is the data source external or internal?
    • If it’s external, could you share the database type and the specific column data type?

  3. If you’re using the open-source version, please share the underlying database and column type. Additionally include the app version you are using.

3

Thanks -
Running self-hosted, and using native NocoDB backing against version 0.262.5

Happy to import the data into a Postgres-backed DB and views and see if it’s different

Cheers

4

At the moment which database are you using ?