Your default setting does NOT mean the data you put into db IS utf8. Try digging out what content you inserted chokes. Are they really in utf8? Note that unicode is NOT utf8. Hope this info can give a right direction.
On Oct11, 2:39pm, leone <[email protected]> wrote: > Yes, I have added .encode('utf8') to my default > > Field('subject','text', default=u''.encode('utf8')), > > On 11 Ott, 01:53, Iceberg <[email protected]> wrote: > > > > > On Oct11, 3:42am, leone <[email protected]> wrote: > > > > I have same string inserted in a table. > > > When I select them, I debug this error: > > > > File "/xxxxxx/xxxxxx/web2py/web2py/gluon/sql.py", line 2235, in > > > response > > > return self._db._cursor.fetchall() > > > OperationalError: Could not decode to UTF-8 column 'subject' with text > > > 'xxxxxxxxx xxxxxxxxi xxxxxxx' > > > > This is a problem of sql.py module. What can I do? > > > Thanks > > > Did you ever try searching "utf8" in this group or in google? That is > > very likely a common utf8 issue. See this. > > >http://groups.google.com/group/web2py/browse_frm/thread/e9bc715d7d10458a --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---
