Quick Search case insensitive

This public forum is for user-to-user discussions of PHPMaker. Note that this is not support forum.
Post Reply
richardelima
User
Posts: 21

Quick Search case insensitive

Post by richardelima »

How to make Quick Search case insensitive ? thanks.

Top
arbei
User
Posts: 9356

Post by arbei »

Double check your database settings and use case insensitive collation.

Top
richardelima
User
Posts: 21

Post by richardelima »

Thanks. it works:
[Tools]->[Advanced Settings]->[Collation for Like operator (MySQL)] = utf8_general_ci
ci means case insensitive.

Top
Post Reply

Return to “General Discussion (PHPMaker)”