[postmodern-devel] character encoding

[Roman Budzianowski]

Marijn,

I tried setting cl-postgres-system:*unicode* to nil and reloading. It  
works!

I notice a non-ascii char: the registered sign. The database is in  
SQL_ASCII encoding, but it contains non ascii chars.
Somehow psql in unicode mode deals with it, but trivial-utf-8 doesn't.

So, it doesn't have anything to do with postmodern. However, maybe it  
would be useful to be able to set
encoding mode per connection? Any other suggestions?

It seems that this is a not uncommon case.

Roman

CL-USER> (pomo:query "SELECT item_description FROM web_source_items  
WHERE (id = 22225)")
(("<br>The Aeroneb® Go Micropump Nebulizer is a fast, efficient,  
simple-to-use device developed for the millions of patients worldwide  
who require respiratory therapy in and away from home, and eliminates  
many of the problems associated with current methods of ......
and water, and disinfected (if desired)."))


On Sep 10, 2008, at 9:54 AM, Marijn Haverbeke wrote:

> Hey Roman,
>
> There are indeed only ascii characters in that record. Anyway, I can't
> reproduce the problem with this information: I still don't know what
> your table looks like, and which encoding the database uses... if the
> database isn't too huge, could you try dumping it, importing it into a
> new database with the same encoding, testing whether the problem still
> occurs, and if yes, delete most of the rows, dump again, and send to
> me?
>
> Best,
> Marijn
> _______________________________________________
> postmodern-devel mailing list
> postmodern-devel at common-lisp.net
> http://common-lisp.net/cgi-bin/mailman/listinfo/postmodern-devel