How to ignorecase when validatortype is unique?

[chenxuewen]

Hi,everyone
i have a question: when i use validator which type is unique,how could i ignore the case?for example,there is a "Test" in database, so attempt to insert "test" will be returned failure by validator.

[tgilbert]

Hi Isomorphic,

I have the exact same problem... Under Oracle, I really would like to use the built-in isunique validator but non case-sensitive.
Is it possible?

Many thanks for your help,

Thomas

[Isomorphic]

Sorry, there's no setting to cause this validator to be case-insensitive. But if you take a look at the serverCustom validation samples you'll see that it's pretty easy to write either a Velocity expression or a few lines of script to use a case-sensitive operator.