search case sensitive?
Hey Ray
Just wondering if there is a way (and how) to make search NOT case sensitive on, for example, the attached page?
Many thanks
Jamie
Hey Ray
Just wondering if there is a way (and how) to make search NOT case sensitive on, for example, the attached page?
Many thanks
Jamie
Case sensitivity is controlled by the character setting you used for the field in the database itself. Go to the table and column and check the collation value for that column. You can then do a google search to find which collate values are case sensitive and not to set them appropriately for your application.
There are ways to do this in the SQL statement if you want some searches to be case sensitive and others not by updating the collate value on the fly, but I've always done it in the database itself.
Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.
These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.