Salam
brother nabeel
i want one help from u
we are creating small application in urdu using php/mysql
we defined page like
<!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>
<title>Fatawa Jamiya Islamiya Akkalkuwa</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
and our database collation is utf8_unicode_ci, we used
ALTER DATABASE `fatawa` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci
and table collation is utf8_unicode_ci, we used
ALTER TABLE `book` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci
even the fields are utf8_unicode_ci, we used
ALTER TABLE `book` CHANGE `b_name` `b_name` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL
but when we store some urdu value like بسم اللہ
it becomes in database like this .....مت٠رقات
yes when we fire select query from our webpage it looks fine like بسم اللہ
but when we see database from php my admin it shows مت٠رقات
can you solve the problem or give me sample of single page which we can use for our application
May allah bless you.