BUG #13965: Maybe a problem with ODBC UNICODE driver working like ANSI - Mailing list pgsql-bugs

From baptiste.gonod@gmail.com
Subject BUG #13965: Maybe a problem with ODBC UNICODE driver working like ANSI
Date
Msg-id 20160217084215.26357.92495@wrigleys.postgresql.org
Whole thread Raw
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      13965
Logged by:          Bat Go
Email address:      baptiste.gonod@gmail.com
PostgreSQL version: 9.3.0
Operating system:   Windows 7 PRO x64
Description:

Hi,
I've transfered an ANSI database to UTF8. And when I use the UNICODE ODBC
driver (with simply php file), it's the same result as using the ANSI ODBC
driver (so bad accents cause data are in UTF8). I've tried with an other way
to get my data (pgsql) and there's no problem.
So I concluded the UNICODE driver is bugged !

Using pdo in php to send query :

ERROR HERE (using odbc) :
$connec = new PDO('odbc:odbc_utf8');
and odbc_utf8 configuration :
data source : odbc_utf8
server : my_server
User Name : postgres
Password : pwd

NO ERROR HERE (using pgsql) :
$connec = new PDO("pgsql:host=192.33.50.178;dbname=database", "postgres",
"pwd");

I don't know if there's something in the apache or php conf which can cause
this !

pgsql-bugs by date:

Previous
From: ruxandra.durus@vauban.ro
Date:
Subject: BUG #13964: unexpected result from to_tsvector
Next
From: Bruce Momjian
Date:
Subject: Re: BUG #13440: unaccent does not remove all diacritics