Marijn Haverbeke <mari...@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:
  • Some ascii.
  • Some UTF–8 (exists in latin 1): é
  • Some UTF–8 (does not exist in latin 1): ’
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,

-- 
Nicolas Martyanoff
   http://codemore.org
   khae...@gmail.com
_______________________________________________
postmodern-devel mailing list
postmodern-devel@common-lisp.net
http://common-lisp.net/cgi-bin/mailman/listinfo/postmodern-devel

Reply via email to