Marijn Haverbeke marijnh@gmail.com writes:
Hm. Then, this would suggest a bug somewhere. Do simpler non-ascii things work? (For example, walk through the quickstart.) Can you give me your Postgres version, and the exact query that goes wrong?
Yep, no problem with ascii.
I attached the test file I used:
The query is:
(postmodern:execute (:update 'posts :set 'title title 'content content 'content-html content-html 'creation-date (date-format-iso-8601 creation-date) 'visible visible-p :where (:= 'id id)))
Where content-html contains the string read from the html file.
I then get the following error:
Database error 08P01: invalid message format Query: UPDATE posts SET title = E'Test', content = E'- Some ascii. - Some UTF-8 (exists in latin 1): é - Some UTF-8 (does not exist in latin 1): ’', content_html = E'<ul
<li Some ascii.</li <li Some UTF–8 (exists in latin 1): é</li <li Some UTF–8 (does not exist in latin 1): ’</li </ul ', creation_date = E'2011-02-03 08:13:43+01:00', visible = true WHERE (id = E'1')
[Condition of type CL-POSTGRES:DATABASE-ERROR]
Regards,