Hi All, I am trying to fetch some Bangla text from a MySQL database. I am using standard mysql_fetch_array to get information. Now the problem is, unicode characters don't come up. Instead I see a string of question marks. I have included all details here, any help will be highly appreciated.
The output page can be see from http://www.ramadan.com.au/rac/test.php Here's the table structure: Field Type Collation Attributes Null Default Extra Action *surah_no* tinyint(3) UNSIGNED No 0 [image: Browse distinct values] [image: Change] [image: Drop] [image: Primary] [image: Unique] [image: Index] [image: Fulltext] surah_name varchar(255) utf8_unicode_ci No [image: Browse distinct values] [image: Change] [image: Drop] [image: Primary] [image: Unique] [image: Index] [image: Fulltext] Here's how it looks when I click on browse. [image: Full Texts] surah_no Surah number according to the Quransurah_name Name of the Surah according to the Quran [image: Edit] [image: Delete] 27 আন নামল Here's the actual code test.php. Basically I am trying to put all the information in a table. <?php // Connecting, selecting database $link = mysql_connect('localhost', '<hidden>', '<hidden>') or die('Could not connect: ' . mysql_error()); echo 'Connected successfully'; mysql_select_db('<hidden>') or die('Could not select database'); // Performing SQL query $query = 'SELECT * FROM tov_surah'; $result = mysql_query($query) or die('Query failed: ' . mysql_error()); // Printing results in HTML echo "<table>\n"; while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) { echo "\t<tr>\n"; foreach ($line as $col_value) { echo "\t\t<td>$col_value</td>\n"; } echo "\t</tr>\n"; } echo "</table>\n"; echo "টেস্ট"; ?> Regards Imran
