So the value has to be Endcoded From Unicode into UTF8 before inserting? i am sure keys are str.
We cannot store Unicode values ? On 5/31/11, Massimo Di Pierro <massimo.dipie...@gmail.com> wrote: > I am not sure there is a problem here. I cannot help without seeing an > example of the data you insert. > > If you do: > > db.table.insert(**a) > > a must be a dictionary with str key and str (ut8 encoded) values. You > cannot have unicode field names. > > Massimo > > > > On May 31, 2:40 am, Phyo Arkar <phyo.arkarl...@gmail.com> wrote: >> I have the exactly same problem here. >> >> Can anyone look into it? thanks alot. >> >> Stef have you found a solution? >> >> >> >> >> >> >> >> On Fri, Nov 5, 2010 at 5:47 PM, Stef Mientki <stef.mien...@gmail.com> >> wrote: >> >> > I'm trying to insert a record with a filed value >> > u"ëLocatie" >> >> > and I get an error in sql.Table._insert at the last line: >> > return 'INSERT INTO %s(%s) VALUES (%s);' % (sql_t, sql_f, sql_v) >> >> > here the traceback >> > File "D:\Data_Python_25\support\Web2Py_DAL_support.py", line 250, in >> > DAL_Table >> > Description = Value[3][:-1]) >> > File "P:\Web2PY\web2py_src\web2py\gluon\sql.py", line 2035, in insert >> > query = self._insert(**fields) >> > File "P:\Web2PY\web2py_src\web2py\gluon\sql.py", line 2028, in _insert >> > return 'INSERT INTO %s(%s) VALUES (%s);' % (sql_t, sql_f, sql_v) >> > UnicodeDecodeError: 'ascii' codec can't decode byte 0xc3 in position 35: >> > ordinal not in range(128) >> >> > I don't understand the problem and know what I'm doing wrong >> >> > Wwith print statements I tried to narrow the problem, and in : >> > def sql_represent(obj, fieldtype, dbname, db_codec='UTF-8'): >> >> > there's is this part >> > if isinstance(obj, unicode): >> > print '????', type(obj),obj >> > if len(obj)>0 : print ord(obj[0]) >> > obj = obj.encode(db_codec) >> > print '????', type(obj) >> > if len(obj)>0 : print ord(obj[0]) >> >> > which seems to convert the unicode to a string with byte values larger >> > than 128. >> >> > Am I doing something wrong, or is this a bug ? >> > And of course far more interesting, how do I solve this problem ? >> >> > thanks, >> > Stef Mientki