Skip to content

Support case sensitive or insensitive search

← Search

Note this is note a phpGrid specific feature, but a database one.

With exception of DB2 database, most of RDBM databases can support case sensitive/insensitive search via collation settings.

MySQL

https://dev.mysql.com/doc/refman/8.0/en/case-sensitivity.html

PostgreSQL

https://docs.actian.com/ingres/10.2/index.html#page/Upgrade/Collation_Specification_at_the_Column_Level.htm

SQL Server

https://learn.microsoft.com/en-us/ef/core/miscellaneous/collations-and-case-sensitivity

Oracle

https://blogs.oracle.com/sql/post/how-to-do-case-insensitive-and-accent-insensitive-search-in-oracle-database

Searching…

No results.
Clear search results

Give feedback
- General 45 ideas
Knowledge Base
- Accounts6 articles
- Common Issues17 articles
- Database11 articles
- Datagrid Display71 articles
- Datagrid Edit81 articles
- Events9 articles
- Export6 articles
- Future Release2 articles
- Installation10 articles
- Look & Feel8 articles
- Master Detail / Subgrid16 articles
- Misc.23 articles
- Mobile Devices1 article
- Performance1 article
- phpGrid Lite WordPress Plugin1 article
- Pre-built Apps2 articles
- Search11 articles
- SQL Query9 articles
- System Integration9 articles
- WordPress2 articles
- All articles
phpGrid