On 2 December 2015 at 09:59, Encompass solutions <[email protected]> wrote:
> I am not sure this exists yet, but it would be nice to take a string field > (or anything string like) and make it case insensitive. That way I don't > have to worry the [email protected] is the same as [email protected] > What do you guys think? > > If you use PostgreSQL as backend you can activate the extension 'citext' and then in web2py do something like this: citext = SQLCustomType( type ='text', native='citext' ) and in your model: db.define_table('words', Field('word', citext)) Regards Johann -- Because experiencing your loyal love is better than life itself, my lips will praise you. (Psalm 63:3) -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
