[web2py] Re: custom auth table email field set to unique=True accepts non unique values with different case.

2015-11-05 Thread arihant daga
Thank you anthony On Wednesday, November 4, 2015 at 11:09:34 PM UTC+5:30, arihant daga wrote: > > In custom auth table even if email field is set to unique=true, if user > inputs two different values different in case ex.( 'em...@gmail.com' and ' > em...@gmail.com' ) it will accepts both and

[web2py] Re: custom auth table email field set to unique=True accepts non unique values with different case.

2015-11-04 Thread Anthony
unique=True is enforced by the database, not web2py, so it may be case sensitive depending the backend. Also, failures will result in a database error rather than a nice error message reported to the user in the UI. Instead, you should rely on validators to manage this: Field('email',