From: | Bjørn T Johansen <btj(at)havleik(dot)no> |
---|---|
To: | John DeSoi <desoi(at)pgedit(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Could not convert UTF-8 character to ISO8859-1? |
Date: | 2005-07-24 21:26:42 |
Message-ID: | 42E40792.8060709@havleik.no |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Jamie Deppeler | 2005-07-24 22:58:44 | Re: Problems compiling Postgresql 8.0.3 on 10.4 |
Previous Message | Andreas | 2005-07-24 21:01:46 | Re: Bad locking with MS-Access |