alexielle51
New Member
Hi,
I want to extract data from my Progress database in PHP. I have a problem with the special characters, indeed the signs like € or $ are replaced by .
I'm using PDO but I don't know where to manage my charset with Progress.
Here is my code
Can anyone help me ?
I want to extract data from my Progress database in PHP. I have a problem with the special characters, indeed the signs like € or $ are replaced by .
example : Price 2.99
I'm using PDO but I don't know where to manage my charset with Progress.
Here is my code
function Connection_Progress() {
try {
return new PDO('odbcRIVER={Progress OpenEdge 11.7 Driver};DSN=azprod;PORT=2513;HOSTNAME=192.168.120.29;UID=***;PWD=***;db=***;charset=utf8');
}
catch(PDOException $e) {
var_dump($e);
}
}
$stmt = $pdo->query('SELECT DISTINCT * FROM PUB.fabr');
Can anyone help me ?