[web2py] Empty Database value is not None, but an empty string

[Mark Li]

I have a table defined in the following manner:

db.define_table('songinfo',
Field('songtitle'),
Field('artist'))

When I add an empty entry, or upload a CSV with empty values, I can only 
access those values with a database call like

songs = db(db.songinfo.artist=="").select()

as opposed to db(db.songinfo.artist==None).select()


The web2py book states that fields default=None, but I'm getting an empty 
string. Is there an appropriate way to have None instead of an empty string 
in the database?


--