| 7 | | |
| 8 | | Replying to [comment:4 Jun Omae]: |
| 9 | | > It seems the exception is raised when stored bytes string is unable to fail to decode to unicode. So, I guess text in the `value` column is not a valid utf-8 string. |
| 10 | | > |
| 11 | | > See https://github.com/ghaering/pysqlite/blob/2.6.0/src/cursor.c#L389. |
| 12 | | > |
| 13 | | > TEXT column in SQLite can have an invalid utf-8 string (`x'F020F0'` is invalid utf-8 string). |
| 14 | | > {{{#!sqlite3 |
| 15 | | > sqlite> INSERT INTO session_attribute (sid, authenticated, name, value) |
| 16 | | > ...> VALUES ('blah', 1, 'name', x'F020F0'); |
| 17 | | > sqlite> SELECT sid, authenticated, name, value, HEX(value) |
| 18 | | > ...> FROM session_attribute |
| 19 | | > ...> WHERE sid='blah' AND authenticated=1 AND name='name'; |
| 20 | | > blah|1|name|� �|F020F0 |
| 21 | | > }}} |
| 22 | | > |
| 23 | | > Could you please post results of the following query in your `trac.db`? |
| 24 | | > |
| 25 | | > {{{#!sql |
| 26 | | > SELECT sid, authenticated, name, value, HEX(value) |
| 27 | | > FROM session_attribute |
| 28 | | > WHERE value GLOB '*Johan*Otter*'; |
| 29 | | > }}} |
