From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | Pierre Couderc <pierre(at)couderc(dot)eu>, pgsql-odbc(at)postgresql(dot)org |
Subject: | Re: Transcoding problem with wine and unixodbc |
Date: | 2014-04-30 15:34:11 |
Message-ID: | 536117F3.5060700@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
On 04/30/2014 07:36 AM, Pierre Couderc wrote:
> Thank you. I comment.
>>
> As expected by me, as pgAdminIII, psql prints correctly.
Just to be clear where are you connecting from with psql?
>> ANSI is a general term. What is important is what character
>> set(encoding) you are actually using in your application.
>>
> LATIN1 (ISO-8859-1),
Well that should work with the Unicode driver. My guess is there is some
sort of confusion of what the encoding is between the app - psqlodbc -
Postgres.
Is the database you are using only used by your application?
If it is, one possible troubleshooting method would be to set
client_encoding in postgresql.conf to latin1. This will affect all the
clients connecting to your database, so use with care. For more
information see below:
http://www.postgresql.org/docs/9.3/interactive/multibyte.html#MULTIBYTE-CHARSET-SUPPORTED
>>> And I do not know who is responsible for translation, normally it should
>>> be the unixodbc or psqlodbc..
>
>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Paquier | 2014-05-01 03:18:00 | Re: CC_send_query_append crash |
Previous Message | Pierre Couderc | 2014-04-30 14:36:56 | Re: Transcoding problem with wine and unixodbc |