*My problem is solved. Thank you Bruno!!!*
*I used to set this field to integer and then changed it to string.*
*So... now it's OK - I set CHAR type for the field in SQLITEMAN.*
On Wednesday, August 8, 2012 11:35:13 PM UTC+4, rochacbruno wrote:
>
> 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....@gmail.com<javascript:>
> > 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?
>>
>> --
>>
>>
>>
>>
>
>
--
