I need to retrieve Cyrillic data from MSSQL database with PHP but I get back "???????

M

MBMSOFT

Registered User.

Local time

Today, 14:17

Joined

Jan 29, 2010

Messages

90

• May 21, 2015

• #1

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 "???????"

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...

 

Y

youyiyang

Registered User.

Local time

Today, 21:17

Joined

Apr 7, 2009

Messages

49

• Sep 3, 2017

• #2

Re: I need to retrieve Cyrillic data from MSSQL database with PHP but I get back "???

the problem is in your client side.
use this in your client side html page:
<meta charset=utf-8>
references:
https://technet.microsoft.com/en-us/library/ms190252(v=sql.105).aspx

https://stackoverflow.com/questions/22735993/html5-encoding-cyrillic

 

arnelgp

..forever waiting... waiting for jellybean!

Local time

Today, 21:17

Joined

May 7, 2009

Messages

20,674

• Sep 3, 2017

• #3

Re: I need to retrieve Cyrillic data from MSSQL database with PHP but I get back "???

Uh, check the post date.

 

A

abubasil

Registered User.

Local time

Today, 16:17

Joined

Aug 31, 2011

Messages

29

• Jan 4, 2019

• #4

Re: I need to retrieve Cyrillic data from MSSQL database with PHP but I get back "???

A new reply for an old question for anyone drop in here.

The solution is to set the database, tables , and fields collation to utf8_unicode_ci.
as for the php files make them encode utf8 in BOM .