Is that SQLITE? did you created it as integer and after that changed to string?
SQLITE does not have ALTER-TABLE command, so even if you change a field from integer to string, web2py will see it as string, but the db will still store as integer. You need to change the datatype to CHAR() on your sqlite database (use sqliteman) or remove and recreate the db, or change the field name. On Wed, Aug 8, 2012 at 4:27 PM, Vladimir Makarov <vlad.mul...@gmail.com>wrote: > Hi there! I am a bit puzzled by the following problem. > > In my db.py file I use *string *type for the field. > Field('ras', 'string', label=T('Account'), > requires=IS_NOT_EMPTY(error_message='you should enter number of your > account')), > But when I insert some value into this field, for example * > 30101810000000000722*, it stores as *3.010181e+019*. > What's the matter? > > -- > > > > --