I just started working with web2py and have what is probably a simple
question on database validation. Below is what I have in db.py.
Currently this will allow duplicate names that are in different cases
(e.g. Firm 1 and firm 1). I want to make it so that it won't allow
this but stores the name in the database the way the person enters it,
so I don't want to convert everything to upper or lowercase and store
it that way. Thanks in advance for any help.
db.define_table('firm',
Field('name', unique=True))
db.firm.name.requires = [IS_NOT_EMPTY(), IS_NOT_IN_DB(db, 'firm.name')]
