Using web2py 1.87.2 with sqlite I need to store and retrieve a list of strings from a multple select. I have a case where the list can be the empty list []. It will encode to the datebase as '||', but will decode to ['|'], not [].
The current gluon.sql.py is: def bar_encode(items): return '|%s|' % '|'.join(bar_escape(item) for item in items if str(item).strip()) def bar_decode_string(value): return [x.replace('||','|') for x in string_unpack.split(value) if x.strip()] I believe the following would fix this: def bar_decode_string(value): return [x.replace('||','|') for x in string_unpack.split(value[1:-1]) if x.strip()]