Re: Could not convert UTF-8 character to ISO8859-1? - Mailing list pgsql-general

From John DeSoi
Subject Re: Could not convert UTF-8 character to ISO8859-1?
Date
Msg-id 85B827BC-54EB-4EB8-88BD-4D3E2C276BFD@pgedit.com
Whole thread Raw
In response to Re: Could not convert UTF-8 character to ISO8859-1?  (Bjørn T Johansen <btj@havleik.no>)
Responses Re: Could not convert UTF-8 character to ISO8859-1?
List pgsql-general
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


pgsql-general by date:

Previous
From: Bjørn T Johansen
Date:
Subject: Re: Could not convert UTF-8 character to ISO8859-1?
Next
From: "Stefan"
Date:
Subject: get sequence from remote server