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. >>> >> --