clsql problems with postgresql
[email protected] (Dr. Michael Dowling)
| Newsgroups | gmane.lisp.clsql.general |
|---|---|
| Message-ID | <20091003151710.GA2718@moocow> |
Hello! before I begin, I should say that I cannot answer email from Monday until Thursday as I work in another city without Internet access on these days. I am new to this list and to CLSQL, so I hope that I am on topic. I'm using Arch Linux x86_64 with sbcl-1.0.31. I have two problems. After getting CLSQL to connect to my postgresql database under Arch Linux, there came an upgrade for postgresql to version 8.4.1, whereupon CLSQL failed to connect. So, can it be that CLSQL requires upgrading for this version, and, if so, can anybody point me to a patch? The second problem I think concerns character coding. At least I could get a response to my SQL queries _provided_ there were no German national characters involved in the output. This remains true if I use an SQLite database instead of a PostgreSQL one. At least, that seems to me to be the common cause. I use iso-5589-15 character encoding both for my Linux environment and for the postgreSQL database. Could it be that CLSQL insists on UTF8 encoding? Can this be altered? Finally, both these problems have one aspect in common. I get no error message; I am not thrown into the lisp debugger; the REPL is simply killed without comment! That strikes me as being extreme! I would be very grateful for any help on these topics. Thanks in advance, Mike Dowling -- Dr. Michael L. Dowling Gaußstr. 27 38106 Braunschweig Germany