PHP - Fetching UTF-8 data from sqlsrv database

Question

I'm Trying to fetch some data from sql server database and print in json , but some of the data in database is in UTF-8 (Arabic) . I searched the web and tried many solutions , but none of them worked for me , any help would be appreciated . Here is my code :

<?php

$serverName = "127.0.0.1"; //serverName\instanceName
$connectionInfo = array( "Database"=>"filmnak_com_", "CharacterSet" => "UTF-8", "UID"=>"filmnak", "PWD"=>"G5j^wk44");
$conn = sqlsrv_connect( $serverName, $connectionInfo);

$sql = "SELECT CAST(ID AS INT) AS ID, CAST(Film AS TEXT) AS Film ,CAST(Name AS TEXT) Name FROM dbo.Movies";

$result = sqlsrv_query( $conn, $sql);
if( $result === false ) {
     die( print_r( sqlsrv_errors(), true));
}

    // looping through all results
    // products node
    $response["Info"] = array();
  while ($row = sqlsrv_fetch_array($result)) {
        // temp user array
        $Info = array();
        $Info["ID"] = $row["ID"] ;
        $Info["Film"] = $row["Film"];

      $Info["Name"] = utf8_decode($row["Name"]);

    echo $row["Name"];
        // push single product into final response array
        array_push($response["Info"], $Info);
    }


echo json_encode($response , JSON_UNESCAPED_UNICODE);

sqlsrv_free_stmt($result);


?>

the result in browser :

???? ????1+1?????{"Info":[{"ID":8,"Film":"8O9","Name":"???? ????"},{"ID":9,"Film":"9O3","Name":"1+1"},{"ID":10,"Film":"10O5","Name":"?????"}]}

+ use the type nvarchar (or other similar like ntext, nchar — Karthi
– Karthi, Commented Nov 12, 2016 at 12:28
utf8_decode never does what you think it does. If your data is UTF 8 in the database and your connection charset is UTF 8 then PHP will receive it as UTF 8. PHP can handle UTF-8 just fine, no need for any special operations on them. — apokryfos
– apokryfos, Commented Nov 12, 2016 at 12:30
@apokryfos , the data in database is UTF-8 , I set the characterset to UTF-8 , but when i use echo to print them , it will show question marks (?????) , ( echo $row["Name"]; gives question marks , utf8_decode($row["Name"]); gives question marks ) — Arash Mohammadi
– Arash Mohammadi, Commented Nov 12, 2016 at 12:58

Arman · Accepted Answer · 2018-07-22 14:54:45Z

19

USE THIS CODE

    $serverName="(local)";
    $connetionInfo = array("DataBase"=>"your db","UID"=>"username","PWD"=>"pass",
                           "CharacterSet" => "UTF-8");<---------------this
    $this->dblink=sqlsrv_connect($serverName,$connetionInfo);

answered Jul 22, 2018 at 14:54

Arman

1911 silver badge3 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Skatox · Accepted Answer · 2022-04-11 17:06:06Z

3

You'll need to specify the character set when connecting to the sqlsrv server. You can do this by adding the CharacterSet parameter like this:

$serverName = "Your server name";
$connectionInfo = [ "Database"=>"your db",  "CharacterSet" =>"UTF-8"];
$conn = sqlsrv_connect( $serverName, $connectionInfo);

edited Apr 11, 2022 at 17:06

Skatox

4,27412 gold badges47 silver badges50 bronze badges

answered Apr 10, 2022 at 9:57

Yrys

311 bronze badge

Comments

Mahmood Rezaei · Accepted Answer · 2022-07-23 10:41:47Z

1

Set the database collation to utf8_general_ci

answered Jul 23, 2022 at 10:41

Mahmood Rezaei

262 bronze badges

Collectives™ on Stack Overflow

PHP - Fetching UTF-8 data from sqlsrv database

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related