From: | Dick Kniep <dick(at)lindix(dot)nl> |
---|---|
To: | psycopg(at)postgresql(dot)org <psycopg(at)postgresql(dot)org> |
Subject: | Weird unicode problem |
Date: | 2015-04-15 13:50:28 |
Message-ID: | zarafa.552e6ca4.2698.3ff0d24e74a5df3f@mail.int.lindix.nl |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | psycopg |
Hi list,
We use Postgresql 9.3 on Ubuntu 14.04 with psycopg2 and python2.7 on Ubuntu 12.04
Now we have a Euro sign (€) in a text field. When I try to retrieve the row I get the following traceback:
2015-04-15 14:48:00,918 ERROR comsupport.dick SQLDict 326 SELECT "per_id", "lob_id", "lob_datum", "soortentry", "gelezen", "txthdr", "lob_text", "ondhpgm", "mutmed", "mutdat", "per_naam1", "lob_categorie", "prive", "classificatie
", "entry_owner", "dossier", "toturen", "ncat_id", "cli_id", "doel_tekst", "doel_gehaald", "doel_tonen", "doel_title", "doel_plandate", "hdoel_id", "tab_id", "doel_id", "tab_naam", "tab_naam_kort", "ingangsdatum", "vervaldatum",
"note_sjabloon_title", "note_sjabloon", "mimetype" FROM "comsupport"."vwclasslogboek" sqd1 WHERE per_id = 61 AND (classificatie in (3679,3386,0) or classificatie is null) AND lob_categorie in ('E','H') order by lob_datum DESC
, mutdat DESC
2015-04-15 14:48:00,919 ERROR comsupport.dick SQLDict 327 parameters ()
2015-04-15 14:48:00,920 ERROR comsupport.dick SQLDict 328 Exception
Traceback (most recent call last):
File "/opt/CVix-prod/src/SQLConnect/SQLDict.py", line 319, in executeSQL
self._resultcursor.execute(stmt)
DataError: character with byte sequence 0xe2 0x82 0xac in encoding "UTF8" has no equivalent in encoding "LATIN1"
But I don't understand this because I have added a type caster to the connection like so:
import psycopg2
import psycopg2.extensions
import psycopg2.extras
psycopg2.extensions.register_type(psycopg2.extensions.UNICODE)
psycopg2.extensions.register_type(psycopg2.extensions.UNICODEARRAY)
Now I thought that after adding this, conversion to unicode is executed automagically????
Cheers,
D. Kniep
Lindix BV
From | Date | Subject | |
---|---|---|---|
Next Message | Daniele Varrazzo | 2015-04-15 14:13:57 | Re: Weird unicode problem |
Previous Message | Daniele Varrazzo | 2015-03-30 14:43:06 | Re: Segfault in BackendIdGetTransactionIds with psycopg2 |