So I been looking for a couple hours on a solution to this but it evades me.
When I create a unique field such as: db.define_table('list', Field('name, unique=True)) I can add "David", "david" and "dAvid" and they are all rightfully unique and added accordingly. How do I add a field so it doesn't matter the case or capitalization? I only want "David" or any variation in the table only 1 time. The reason is I want to keep the case as a specific name like "ForEx" or "NASDAQ" but not "forex" or "nasdaq". Thanks, David -- 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 web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.