Thanks again, I'll look into this method.
Greg Miller
--
http://mail.python.org/mailman/listinfo/python-list
On 18 Nov 2005 09:09:24 -0800, "Greg Miller" <[EMAIL PROTECTED]>
wrote:
>Thank you for all your suggestions. I ended up casting the string to
>unicode prior to inserting into the database.
>
Don't do it by hand if it can be done by an automated system.
Try with:
from pysqlite2 import dbapi2
Thank you for all your suggestions. I ended up casting the string to
unicode prior to inserting into the database.
Greg Miller
--
http://mail.python.org/mailman/listinfo/python-list
On 17 Nov 2005 03:47:00 -0800, "Greg Miller" <[EMAIL PROTECTED]>
wrote:
>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
Jarek Zgoda wrote:
> Fredrik Lundh napisa³(a):
>
> >>UnicodeDecodeError: '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 Tex
Fredrik Lundh napisał(a):
>>UnicodeDecodeError: '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 Übereinstimmungsfehler gefunde
Greg Miller enlightened us with:
> 'Keinen Text für Übereinstimmungsfehler gefunden'
You posted it as "Keinen Text fr ...", which is Latin-1, not
UTF-8.
> I thought that all strings were stored in unicode in sqlite.
Only if you put them into the DB as such. Make sure you're inserting
UTF-8 text,
Greg Miller wrote:
> UnicodeDecodeError: '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 Übereinstimmungsfehler gefunden'
$ mor
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:
Trac