Can you try put a u in front of the string u"..."
On Nov 8, 5:30 am, Omri <omri...@gmail.com> wrote: > Hello, > > I'm having a unicode problem with the DAL. > > I'm developing a (mainly) RPC database application with qooxdoo as JS > framework and web2py as the webserver. > > I have created a fairly generic update_record function which simply > gets two input variables - a table name and a data dictionary with > name/value pairs which correspond to the fields of the table. > My function looks like this: > > def update_record(table_name, data): > db(db[table_name]['id'] == data['id']).update(**data) > return db(db[table_name]['id'] == data['id']).select() > > My application should work both in English and in German, and my > problem is that when I try to update a string value with an Umlaut > (example - "Überwlad") I get an error: > "UnicodeDecodeError: 'ascii' codec can't decode byte 0xc3 in > position..." > > I am able to insert records to the database with Umlauts, but I use a > different method for the insert. I use the syntax of .insert(name = > value, name2 = value2,...). > > I tried to encode all the data keys which are unicode objects without > success, it keeps raising the same error. > > Am I missing something here, or is this a bug? And more interestingly, > how can it be solved? > > Thanks, > Omri