Do you know the required syntax to make it happen on the db engine you are
using ?
Remember also that if your db is going to be "filled" (updated, or
inserted) by web2py, you can apply a custom validator: only data inserted
or updated from within web2py will be "checked"
On Saturday, June 23, 2012 3:29:48 AM UTC+2, Corey Marques wrote:
>
> OK, maybe this is a better question. How to I specify that the column is
> NOCASE using the DAL?
>
>
> On Wednesday, June 20, 2012 4:33:55 PM UTC-4, Corey Marques wrote:
>>
>> Howdy,
>>
>> I'm trying to put together a quick proof of concept to use this framework
>> for porting our desktop application to the web.
>>
>> I ran into an issue where unique fields don't follow our rules. In our
>> database the 'nickname' field is unique and "JOE" is the same as "joe".
>>
>> I did a quick search and couldn't find an elegant solution to this
>> problem. I was hoping for something like
>>
>> Field('nickname', unique_ignore_case=True)
>>
>> Is there a simple and efficient way to do this? The only solution I was
>> able to find involved duplicating the field on the table and saving both
>> the field and it's lowercase equivalent.
>>
>> Thanks for your time.
>>
>> Corey.
>>
>
--
