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?
>
>  --
>
>
>
>

-- 



Reply via email to