I know that for SQLite (what I'm using for the proof of concept) it's 
actually NOCASE. 



On Saturday, June 23, 2012 4:28:44 AM UTC-4, Niphlod wrote:
>
> 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.
>>>
>>

-- 



Reply via email to