title: Retrieving East Asian language data from SQL SERVER database
body: <p>Currently I am getting the data from <strong>SQL Server</strong> using <strong>PHP 3.5</strong> and I am returning in <strong>Json</strong> format. But in my database I have data in different languages like <strong>Chinese, Thai, Japanese, Korean</strong> and etc. when I return the data it shows in this format:  <strong>??????</strong> </p>
  
  <p>How can I show the data in original format?
  below is my code:</p>
  
  <pre><code>$query = "SELECT                   
                 [name]
                ,[venue]                
                FROM tablename
                WHERE id = '2'";
  
  /**********************************************/
  //Just for the Purpose of Count Number of Rows
  $params = array();
  $options =  array( "Scrollable" =&gt; SQLSRV_CURSOR_KEYSET );
  /******************************/
  
  #Query the database to get the user details. 
  $res = sqlsrv_query($conn, $query, $params, $options);  
  
  $arr = array();
  #If no data was returned, check for any SQL errors 
  if ($res == false) 
  { 
     echo 'Query not Executed : '.  die(print_r(sqlsrv_errors(), TRUE));
  }
  else
  {       
      while($obj = sqlsrv_fetch_array($res, SQLSRV_FETCH_ASSOC))
      {
          $arr[] = array(
          "name" =&gt; $obj['name'],
          "venue" =&gt; $obj['venue']
          );
      }
  }
  
  header('Content-type: application/json; charset=utf-8');
  #Output the JSON data 
  echo json_encode($arr);
  exit();
  
  
  sqlsrv_free_stmt($res); // Closes a statement. Frees all resources associated.
  sqlsrv_close($conn);    // Closes a connection. Frees all resources associated.
  </code></pre>