Le 30/04/2014 17:34, Adrian Klaver a écrit :
> 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?
Well, I open a terminal on my amd64 debia, jessie, and I ise psql from it.
> , I open a
>
>
>>> 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.
>
yes.
> 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/runtime-config-client.html#RUNTIME-CONFIG-CLIENT-FORMAT
>
>
> http://www.postgresql.org/docs/9.3/interactive/multibyte.html#MULTIBYTE-CHARSET-SUPPORTED
>
>
>
No, I have many clients.
I must find a way to specify that THIS Client is LATIN1. Is there not a
way to specify it in a connect string ? I find notrhing in the doc.
>>>> And I do not know who is responsible for translation, normally it
>>>> should
>>>> be the unixodbc or psqlodbc..
>>
>>
>
>