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

Yes, that did the trick... I tried to execute the same statement at the same time as I did
the insert, but it needed to be in a separate statement....

Thx.... :)

BTJ

John DeSoi wrote:
>
> 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
>