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

Question

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?

Answer 1

Some SO archive may help you some ideas -

http://stackoverflow.com/questions/1198701/storing-and-displaying-unicode-string-using-php-and-mysql

http://stackoverflow.com/questions/1129808/arabic-text-displaying-in-webapp-without-db-changes

http://stackoverflow.com/questions/457586/what-is-the-best-method-to-build-multilingual-script-in-php

Answer 2

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.

//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");