Forum OpenACS Development: Response to PostgreSQL upper() / lower() functions and LATIN2 charset

I'm just learning about how encodings are handled in
Postgres, but this document contains some useful information. In particular,
it looks like you may need to make sure your interactive pgsql client encoding
is set to your charset if you want to input 8 bit characters
through it.

SET CLIENT_ENCODING TO 'encoding';

To query the current frontend encoding:
SHOW CLIENT_ENCODING;