Re: [plt-dev] pgsql package

Ryan Culpepper wrote:
> Robby Findler wrote:
> > Thanks for the reply, Dave!
> >
> > The encoding of my database is SQL_ASCII which, IIUC, means that the
> > bug really is in the SCheme code side for putting the data in one way
> > and expecting it to come out the other way.
>
> The server has a communication encoding separate from the storage 
> encodings of the actual databases. Communication should happen in UTF-8, 
> and the server should convert data as necessary on storage and retrieval.

... except that, apparently, if the server "encoding" is SQL_ASCII, then 
the data is not transcoded before transmission. So the server might be 
sending out byte sequences that aren't valid according to the client 
encoding. Grrr!

http://www.postgresql.org/docs/8.2/static/multibyte.html
http://lists.exim.org/lurker/message/20070528.055039.01552121.ja.html

> > I don't suppose you (or anyone!) could recommend how this should work?
> > If I change the encoding to latin-1 and then change it to utf-8 and
> > then change it back to SQL_ASCII, woudl htat effectively translate the
> > entire database to utf-8?
>
> I don't know if that would help anything.

I think I was wrong... changing the encoding of the database to UTF8 
seems like it might fix it. I don't know if you can change it in-place, 
though. I found some recommendations for converting the database here:

http://openacs.org/forums/message-view?message_id=190333

Ryan
_________________________________________________
 For list-related administrative tasks:
 http://list.cs.brown.edu/mailman/listinfo/plt-dev