I just did a test using sqlite. It also inserted a column with a null value
Here is a sample code
db.define_table('actividades',
Field('descripcion','string',length=100,label='Descripcion',default='')
)
On Monday, April 4, 2016 at 2:48:10 PM UTC-6, Anthony wrote:
>
> Also, can you check whether the same problem occurs with SQLite?
>
> On Monday, April 4, 2016 at 4:47:33 PM UTC-4, Anthony wrote:
>>
>> Can you show some code? I think Firebird uses the same insert code as the
>> base adapter, and that appears to correctly insert an empty string.
>>
>> Anthony
>>
>> On Monday, April 4, 2016 at 3:54:10 PM UTC-4, Raul Monares wrote:
>>>
>>> It appears that default='' in the field constructor is being ignored.
>>> When I later do an update to the same field with an empty string, it is
>>> stored correctly in the database.
>>>
>>>
>>>
>>> On Friday, April 1, 2016 at 12:41:12 PM UTC-6, Raul Monares wrote:
>>>>
>>>> I'm using Firebird 2.5.4 on Freebsd 10.2
>>>>
>>>>
>>>> On Friday, April 1, 2016 at 12:01:00 PM UTC-6, Dave S wrote:
>>>>>
>>>>> On Thursday, March 31, 2016 at 7:39:23 PM UTC-7, Raul Monares wrote:
>>>>>>
>>>>>> Hello
>>>>>> I just updated to version 2.14.3 and noticed that empty strings are
>>>>>> being stored as null in database field. This didn't happened in 2.13.4.
>>>>>>
>>>>>> Is this the intended behavior ?
>>>>>>
>>>>>
>>>>> Which database engine are you using?
>>>>>
>>>>> /dps
>>>>>
>>>>>
>>>>
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
