I have great problem regarding mysql <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Untitled Document</title> <style type="text/css"> .bangla { font:Solaimanlipi; } </style> </head> <body> <?php $con = mysql_connect("localhost","root","password"); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("quran", $con); $result = mysql_query("SELECT * FROM `quran` LIMIT 0, 30"); echo "<table border='1' class='bangla'> <tr> <th>কà§à¦°à¦®</th> <th>নাম</th> <th>আয়াত সংখà§à¦¯à¦¾</th> </tr>"; while($row = mysql_fetch_array($result)) { echo "<tr>"; echo "<td>" . $row['serial'] . "</td>"; echo "<td>" . $row['name'] . "</td>"; echo "<td>" . $row['ayat'] . "</td>"; echo "</tr>"; } echo "</table>"; mysql_close($con); ?> সূরা আলৠফাতিহা </body> </html> Code (markup): in the page last line is in bengali. It is showing ok. but in the table 1st & 3rd column is ok as they are in english and 2nd column showing "????????" as they are in bengali. I set collation of the mysql table to utf8_bin. In the phpmyadmin page table is absolutely ok. it is showing my bengali characters. but in the above coded page 2nd column showing what symbol instead of bengali character. What may be the problem. plz help me.
See http://saidur.wordpress.com/2007/11/24/bangla-insert-and-retrive-using-php-mysql/ (Anything you need is on the web, the trick is knowing how to find it.)