Thanks!
On 10/8/07, S. M. Ibrahim (Lavlu) <[EMAIL PROTECTED] > wrote: > > run this query > > set names 'utf8' > > before fetch/insert utf-8 data, after complete the fetch/insert don't > forget to run this query (if rest of the data are in latin) > > set names 'latin1' > > On 10/8/07, Imran Hossain < [EMAIL PROTECTED]> wrote: > > > > 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 > > > > > > -- > S. M. Ibrahim (Lavlu) > Web Application Developer > somewherein... > Blog: http://lavluda.com > Yahoo!! ID: lavluda MSN ID: lavluda Skype : lavluda
