Re: [postmodern-devel] encoding problem

2011-02-15 Thread Marijn Haverbeke
> Sorry for the noise, and thank you for trying to help me. No problem, glad to see you figured it out. Cheers, Marijn ___ postmodern-devel mailing list postmodern-devel@common-lisp.net http://common-lisp.net/cgi-bin/mailman/listinfo/postmodern-devel

Re: [postmodern-devel] encoding problem

2011-02-14 Thread Nicolas Martyanoff
Marijn Haverbeke writes: > Hi Nicolas, > > Still no luck reproducing this. Does this simple query fail too? > (query "select '’'") All right, I finally figured out the problem. The string came from a file, which was loaded with: (defun file-read (filename) (with-open-file (stream filename)

Re: [postmodern-devel] encoding problem

2011-02-14 Thread Marijn Haverbeke
Hi Nicolas, Still no luck reproducing this. Does this simple query fail too? (query "select '’'") If not, you might want to double-check your database encodings. Best, Marijn ___ postmodern-devel mailing list postmodern-devel@common-lisp.net http://co

Re: [postmodern-devel] encoding problem

2011-02-13 Thread Nicolas Martyanoff
Marijn Haverbeke writes: >>> Also, again, which version of Postgres are you using? > >> Ooops :) I use the git version, 5fe54bd. > > I meant PosgreSQL, not Postmodern. Postgresql 9.0.3 -- Nicolas Martyanoff http://codemore.org khae...@gmail.com __

Re: [postmodern-devel] encoding problem

2011-02-13 Thread Marijn Haverbeke
>> Also, again, which version of Postgres are you using? > Ooops :) I use the git version, 5fe54bd. I meant PosgreSQL, not Postmodern. ___ postmodern-devel mailing list postmodern-devel@common-lisp.net http://common-lisp.net/cgi-bin/mailman/listinfo/po

Re: [postmodern-devel] encoding problem

2011-02-13 Thread Nicolas Martyanoff
Marijn Haverbeke writes: >> Yep, no problem with ascii. > > Sure, but that's not what I asked. Does this query from the quickstart > work? (query "select 22, 'Folie et déraison', 4.5") This one works. > Also, again, which version of Postgres are you using? Ooops :) I use the git version, 5fe54bd

Re: [postmodern-devel] encoding problem

2011-02-13 Thread Marijn Haverbeke
> Yep, no problem with ascii. Sure, but that's not what I asked. Does this query from the quickstart work? (query "select 22, 'Folie et déraison', 4.5") Also, again, which version of Postgres are you using? ___ postmodern-devel mailing list postmodern-

Re: [postmodern-devel] encoding problem

2011-02-13 Thread Nicolas Martyanoff
Marijn Haverbeke 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: Som

Re: [postmodern-devel] encoding problem

2011-02-13 Thread Marijn Haverbeke
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? Best, Marijn ___ postmodern-devel mailing list postmo

Re: [postmodern-devel] encoding problem

2011-02-13 Thread Nicolas Martyanoff
Marijn Haverbeke writes: > After loading the system, check the value of > cl-postgres-system::*unicode* . Is it T? Yes it is. -- Nicolas Martyanoff http://codemore.org khae...@gmail.com ___ postmodern-devel mailing list postmodern-devel@common

Re: [postmodern-devel] encoding problem

2011-02-13 Thread Marijn Haverbeke
After loading the system, check the value of cl-postgres-system::*unicode* . Is it T? ___ postmodern-devel mailing list postmodern-devel@common-lisp.net http://common-lisp.net/cgi-bin/mailman/listinfo/postmodern-devel

Re: [postmodern-devel] encoding problem

2011-02-13 Thread Nicolas Martyanoff
Ivan Boldyrev writes: > On Mon, Feb 14, 2011 at 1:49 AM, Nicolas Martyanoff < > khae...@gmail.com> wrote: > > > I have a query which inserts text containing the '’' character > (unicode > U+2019). Postmodern seems to generate a correct SQL query, but I > get a > postgresql

Re: [postmodern-devel] encoding problem

2011-02-13 Thread Ivan Boldyrev
On Mon, Feb 14, 2011 at 1:49 AM, Nicolas Martyanoff wrote: > > I have a query which inserts text containing the '’' character (unicode > U+2019). Postmodern seems to generate a correct SQL query, but I get a > postgresql error: > Database error 08P01: invalid message format > > Is your Lisp imple

[postmodern-devel] encoding problem

2011-02-13 Thread Nicolas Martyanoff
I have a query which inserts text containing the '’' character (unicode U+2019). Postmodern seems to generate a correct SQL query, but I get a postgresql error: Database error 08P01: invalid message format The database was created with and UTF-8 encoding. I'm not sure where the problem is, perh