I need to retrieve Cyrillic data from MSSQL database with PHP but I get back "???????
I need to retrieve Cyrillic data from MSSQL database with PHP but I get back "???????"
Result is "?????" instead of cyrillic text
Any idea how to get non-unicode characters from mssql database
Thanks...
I need to retrieve Cyrillic data from MSSQL database with PHP but I get back "???????"
Code:
<?php
$dbconn = new PDO('odbc:Driver=FreeTDS; Server=xxx.xxx.xxx.xx; Port=1433; Database=xxxxxx; UID=xxxx; PWD=xxxxx; )');
if ($dbconn->connect_error) {die("Connection failed: " . $dbconn->connect_error);}
//$dbconn->debug = true;
$sql="select data1 from myTABLE where data2 ='text' ";
$query = $dbconn->query($sql);
$query->execute();
$rs = $query->fetchColumn();
echo $rs;
?>
Result is "?????" instead of cyrillic text
Any idea how to get non-unicode characters from mssql database
Thanks...