BUG #13965: Maybe a problem with ODBC UNICODE driver working like ANSI

From: baptiste(dot)gonod(at)gmail(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #13965: Maybe a problem with ODBC UNICODE driver working like ANSI
Date: 2016-02-17 08:42:15
Message-ID: 20160217084215.26357.92495@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 13965
Logged by: Bat Go
Email address: baptiste(dot)gonod(at)gmail(dot)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 !

Browse pgsql-bugs by date

  From Date Subject
Next Message Teodor Sigaev 2016-02-17 12:06:26 Re: BUG #13440: unaccent does not remove all diacritics
Previous Message ruxandra.durus 2016-02-17 08:00:48 BUG #13964: unexpected result from to_tsvector