I cannot replicate with SQLite. How are you doing the insert, and how are
you verifying the value that ends up in the database?
On Tuesday, April 5, 2016 at 1:00:07 PM UTC-4, Raul Monares wrote:
>
> 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 web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
