On Jul 24, 2005, at 1:52 PM, Bjørn T Johansen wrote:
> I don't think you are correct... UTF-8 might be default on MSSQL,
> but it is the ODBC
> connection to PGSQL that sets the client encoding to UTF-8... (I.e.
> when I just connect to
> the PGSQL server, I get a statement in the PG log file that says
> "set client_encoding to
> 'UTF8'..
>
> And I don't want to use UNICODE on my PG Server....
After you login try executing "SET client_encoding TO LATIN1"
I don't use ODBC so I don't know if this will mess things up, but it
might be worth a try.
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL