Re: Could not convert UTF-8 character to ISO8859-1?

From: John DeSoi <desoi(at)pgedit(dot)com>
To: Bjørn T Johansen <btj(at)havleik(dot)no>
Cc: Ropel <ropel(at)ropel(dot)it>, pgsql-general(at)postgresql(dot)org
Subject: Re: Could not convert UTF-8 character to ISO8859-1?
Date: 2005-07-24 18:23:08
Message-ID: 85B827BC-54EB-4EB8-88BD-4D3E2C276BFD@pgedit.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Stefan 2005-07-24 19:23:58 get sequence from remote server
Previous Message Robert Bernier 2005-07-24 18:14:17 Re: Going to OSCON? We need your help!