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