sqlite utf8 encoding error

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Greg Miller

    #1

    sqlite utf8 encoding error

    I have an application that uses sqlite3 to store job/error data. When
    I log in as a German user the error codes generated are translated into
    German. The error code text is then stored in the db. When I use the
    fetchall() to retrieve the data to generate a report I get the
    following error:

    Traceback (most recent call last):
    File "c:\Pest3\Gloss er\baseApp\repo rtGen.py", line 199, in
    OnGenerateButto nNow
    self.OnGenerate Button(event)
    File "c:\Pest3\Gloss er\baseApp\repo rtGen.py", line 243, in
    OnGenerateButto n
    warningresult = messagecursor1. fetchall()
    UnicodeDecodeEr ror: 'utf8' codec can't decode bytes in position 13-18:
    unsupported Unicode code range

    does anyone have any idea on what could be going wrong? The string
    that I store in the database table is:

    'Keinen Text für Übereinstimmung sfehler gefunden'

    I thought that all strings were stored in unicode in sqlite.

    Greg Miller

Working...