Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › Validation Toolkit › Case sensitive unique db value

Case sensitive unique db value

Thread began 3/01/2021 1:08 pm by Sweens | Last modified 3/02/2021 1:27 pm by Ray Borduin | 241 views | 2 replies |

3/01/2021 1:08 pm | #1 Sweens

Case sensitive unique db value

Hi Ray

I'm using the server validation on a page - things seemed OK, until I deliberately duplicated a value - but used all lowercase letters instead of a mixture (e.g. bread van and Bread Van) and this passed the unique database value validation.

Is there an additional setting I need to use?

Many thanks

Chris

3/02/2021 12:37 pm | #2 Ray BorduinWebAssist

If you update your database column collation to something that is case insensitive and your check will be case insensitive as well.

(any collation that ends in _ci is case insensitive)

Did this help? Tips are appreciated...

3/02/2021 1:23 pm | #3 Sweens

Thanks Ray

It was set as _ci, which led me to check the server behaviour - I had it set to check the id field, not the name filed!

All OK now. Thanks again.

Cheers

Chris

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

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.