How to display arabic characters in web page using php and sql server

How can I display Arabic characters in web page using php and sql server? The Arabic data is stored in the database (sql server). Now I want to use php to display that data on the web page. How can I do this?

  • Is there a way to publish rdl reports programmatically with C#?
  • Replacing alphabets to zero in any given string in SQL
  • SQL Server 2008R2 from Table to edges for Graph
  • Get row for each user where the count of a value in a column is maximum
  • How do you keep two related, but separate, systems in sync with each other?
  • How is the memory used greater than the SQL Server Express limitation?
  • Django app hangs when attempting to connect to database via Apache
  • Connect PHP on Windows to MS SQL Server
  • PDO SQL Server extension faulting intermittently
  • Connecting to an SQL Server Database with PHP
  • work by Apache and port 80
  • SQL Server instead of MYSQL in WAMP
  • 3 Solutions collect form web for “How to display arabic characters in web page using php and sql server”

    Some SO archive may help you some ideas –

    Storing and displaying unicode string (हिन्दी) using PHP and MySQL

    Arabic text displaying in webapp without db changes

    what is the best method to build "multilingual" script in php?

    The official solution for Unicode in mssql with php

    $serverName = "MyServer";
    $connectionInfo = array( "Database"=>"AdventureWorks", "CharacterSet" => "UTF-8");
    $conn = sqlsrv_connect( $serverName, $connectionInfo);
    

    use this in your connection code,
    get more support on utf 8 issue on
    http://msdn.microsoft.com/en-us/library/cc626307.aspx

    Note: its php/mysql based example:

    1. Before you can store Arabic content
      in a database, you need to create a
      table. The following example
      demonstrates the CREATE syntax
    2. You need to make sure your browser supports the character set. <meta
      http-equiv=”Content-Type”
      content=”text/html; charset=UTF-8″>

    SQL Statements:

    //assumed : connection to the database is open
    mysql_query("SET CHARACTER SET utf8");
    mysql_query("SET NAMES 'utf8'");
    // select records
    mysql_query("SELECT * FROM en_authors");
    
    MS SQL Server is a Microsoft SQL Database product, include sql server standard, sql server management studio, sql server express and so on.