neda_barnamenevis
یک شنبه 16 اردیبهشت 1386, 14:26 عصر
سلام
من باphpmyadmin-2.9.1.1و با5.0.26 mysql و با linux10.2کار می کنم
من فیلد هایی از جدول را که فارسی وارد آن می شود را utf8_persian_ci و خود جدولها و دیتابیس latin1_swedish_ci کردم و در فرمphpکه اطلاعات راinsertمی کنم این کد را نوشته ام
!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>
</head>
<body> ولی اطلاعات من در phpmyadminبه این صورت ذخیره می شود.به نظر شما مشکل چیست؟؟
تتلتال http://127.0.0.1/phpMyAdmin/themes/original/img/b_edit.png (http://127.0.0.1/phpMyAdmin/tbl_change.php?db=dic&table=tb2&token=3916e134a016442e0d1dbd95d848efd0&pos=0&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&primary_key=+%60tb2%60.%60idF%60+%3D+13&sql_query=SELECT+%2A+FROM+%60tb2%60&goto=sql.php) http://127.0.0.1/phpMyAdmin/themes/original/img/b_drop.png (http://127.0.0.1/phpMyAdmin/sql.php?db=dic&table=tb2&token=3916e134a016442e0d1dbd95d848efd0&pos=0&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&sql_query=DELETE+FROM+%60tb2%60+WHERE+%60tb2%60.%6 0idF%60+%3D+13+LIMIT+1&zero_rows=The+row+has+been+deleted&goto=sql.php%3Fdb%3Ddic%26table%3Dtb2%26token%3D39 16e134a016442e0d1dbd95d848efd0%26pos%3D0%26session _max_rows%3D30%26disp_direction%3Dhorizontal%26rep eat_cells%3D100%26dontlimitchars%3D0%26sql_query%3 DSELECT%2B%252A%2BFROM%2B%2560tb2%2560%26zero_rows %3DThe%2Brow%2Bhas%2Bbeen%2Bdeleted%26goto%3Dtbl_p roperties_structure.php) 13 آسبی�لی http://127.0.0.1/phpMyAdmin/themes/original/img/b_edit.png (http://127.0.0.1/phpMyAdmin/tbl_change.php?db=dic&table=tb2&token=3916e134a016442e0d1dbd95d848efd0&pos=0&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&primary_key=+%60tb2%60.%60idF%60+%3D+12&sql_query=SELECT+%2A+FROM+%60tb2%60&goto=sql.php) http://127.0.0.1/phpMyAdmin/themes/original/img/b_drop.png (http://127.0.0.1/phpMyAdmin/sql.php?db=dic&table=tb2&token=3916e134a016442e0d1dbd95d848efd0&pos=0&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&sql_query=DELETE+FROM+%60tb2%60+WHERE+%60tb2%60.%6 0idF%60+%3D+12+LIMIT+1&zero_rows=The+row+has+been+deleted&goto=sql.php%3Fdb%3Ddic%26table%3Dtb2%26token%3D39 16e134a016442e0d1dbd95d848efd0%26pos%3D0%26session _max_rows%3D30%26disp_direction%3Dhorizontal%26rep eat_cells%3D100%26dontlimitchars%3D0%26sql_query%3 DSELECT%2B%252A%2BFROM%2B%2560tb2%2560%26zero_rows %3DThe%2Brow%2Bhas%2Bbeen%2Bdeleted%26goto%3Dtbl_p roperties_structure.php) 12 ابیبیبی نیببی http://127.0.0.1/phpMyAdmin/themes/original/img/b_edit.png (http://127.0.0.1/phpMyAdmin/tbl_change.php?db=dic&table=tb2&token=3916e134a016442e0d1dbd95d848efd0&pos=0&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&primary_key=+%60tb2%60.%60idF%60+%3D+10&sql_query=SELECT+%2A+FROM+%60tb2%60&goto=sql.php) http://127.0.0.1/phpMyAdmin/themes/original/img/b_drop.png (http://127.0.0.1/phpMyAdmin/sql.php?db=dic&table=tb2&token=3916e134a016442e0d1dbd95d848efd0&pos=0&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&sql_query=DELETE+FROM+%60tb2%60+WHERE+%60tb2%60.%6 0idF%60+%3D+10+LIMIT+1&zero_rows=The+row+has+been+deleted&goto=sql.php%3Fdb%3Ddic%26table%3Dtb2%26token%3D39 16e134a016442e0d1dbd95d848efd0%26pos%3D0%26session _max_rows%3D30%26disp_direction%3Dhorizontal%26rep eat_cells%3D100%26dontlimitchars%3D0%26sql_query%3 DSELECT%2B%252A%2BFROM%2B%2560tb2%2560%26zero_rows %3DThe%2Brow%2Bhas%2Bbeen%2Bdeleted%26goto%3Dtbl_p roperties_structure.php) 10 چیییییییییییث http://127.0.0.1/phpMyAdmin/themes/original/img/b_edit.png (http://127.0.0.1/phpMyAdmin/tbl_change.php?db=dic&table=tb2&token=3916e134a016442e0d1dbd95d848efd0&pos=0&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&primary_key=+%60tb2%60.%60idF%60+%3D+9&sql_query=SELECT+%2A+FROM+%60tb2%60&goto=sql.php) http://127.0.0.1/phpMyAdmin/themes/original/img/b_drop.png (http://127.0.0.1/phpMyAdmin/sql.php?db=dic&table=tb2&token=3916e134a016442e0d1dbd95d848efd0&pos=0&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&sql_query=DELETE+FROM+%60tb2%60+WHERE+%60tb2%60.%6 0idF%60+%3D+9+LIMIT+1&zero_rows=The+row+has+been+deleted&goto=sql.php%3Fdb%3Ddic%26table%3Dtb2%26token%3D39 16e134a016442e0d1dbd95d848efd0%26pos%3D0%26session _max_rows%3D30%26disp_direction%3Dhorizontal%26rep eat_cells%3D100%26dontlimitchars%3D0%26sql_query%3 DSELECT%2B%252A%2BFROM%2B%2560tb2%2560%26zero_rows %3DThe%2Brow%2Bhas%2Bbeen%2Bdeleted%26goto%3Dtbl_p roperties_structure.php) 9 چطوری http://127.0.0.1/phpMyAdmin/themes/original/img/b_edit.png (http://127.0.0.1/phpMyAdmin/tbl_change.php?db=dic&table=tb2&token=3916e134a016442e0d1dbd95d848efd0&pos=0&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&primary_key=+%60tb2%60.%60idF%60+%3D+15&sql_query=SELECT+%2A+FROM+%60tb2%60&goto=sql.php) http://127.0.0.1/phpMyAdmin/themes/original/img/b_drop.png (http://127.0.0.1/phpMyAdmin/sql.php?db=dic&table=tb2&token=3916e134a016442e0d1dbd95d848efd0&pos=0&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&sql_query=DELETE+FROM+%60tb2%60+WHERE+%60tb2%60.%6 0idF%60+%3D+15+LIMIT+1&zero_rows=The+row+has+been+deleted&goto=sql.php%3Fdb%3Ddic%26table%3Dtb2%26token%3D39 16e134a016442e0d1dbd95d848efd0%26pos%3D0%26session _max_rows%3D30%26disp_direction%3Dhorizontal%26rep eat_cells%3D100%26dontlimitchars%3D0%26sql_query%3 DSELECT%2B%252A%2BFROM%2B%2560tb2%2560%26zero_rows %3DThe%2Brow%2Bhas%2Bbeen%2Bdeleted%26goto%3Dtbl_p roperties_structure.php) 15 تابرتبرا
من باphpmyadmin-2.9.1.1و با5.0.26 mysql و با linux10.2کار می کنم
من فیلد هایی از جدول را که فارسی وارد آن می شود را utf8_persian_ci و خود جدولها و دیتابیس latin1_swedish_ci کردم و در فرمphpکه اطلاعات راinsertمی کنم این کد را نوشته ام
!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>
</head>
<body> ولی اطلاعات من در phpmyadminبه این صورت ذخیره می شود.به نظر شما مشکل چیست؟؟
تتلتال http://127.0.0.1/phpMyAdmin/themes/original/img/b_edit.png (http://127.0.0.1/phpMyAdmin/tbl_change.php?db=dic&table=tb2&token=3916e134a016442e0d1dbd95d848efd0&pos=0&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&primary_key=+%60tb2%60.%60idF%60+%3D+13&sql_query=SELECT+%2A+FROM+%60tb2%60&goto=sql.php) http://127.0.0.1/phpMyAdmin/themes/original/img/b_drop.png (http://127.0.0.1/phpMyAdmin/sql.php?db=dic&table=tb2&token=3916e134a016442e0d1dbd95d848efd0&pos=0&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&sql_query=DELETE+FROM+%60tb2%60+WHERE+%60tb2%60.%6 0idF%60+%3D+13+LIMIT+1&zero_rows=The+row+has+been+deleted&goto=sql.php%3Fdb%3Ddic%26table%3Dtb2%26token%3D39 16e134a016442e0d1dbd95d848efd0%26pos%3D0%26session _max_rows%3D30%26disp_direction%3Dhorizontal%26rep eat_cells%3D100%26dontlimitchars%3D0%26sql_query%3 DSELECT%2B%252A%2BFROM%2B%2560tb2%2560%26zero_rows %3DThe%2Brow%2Bhas%2Bbeen%2Bdeleted%26goto%3Dtbl_p roperties_structure.php) 13 آسبی�لی http://127.0.0.1/phpMyAdmin/themes/original/img/b_edit.png (http://127.0.0.1/phpMyAdmin/tbl_change.php?db=dic&table=tb2&token=3916e134a016442e0d1dbd95d848efd0&pos=0&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&primary_key=+%60tb2%60.%60idF%60+%3D+12&sql_query=SELECT+%2A+FROM+%60tb2%60&goto=sql.php) http://127.0.0.1/phpMyAdmin/themes/original/img/b_drop.png (http://127.0.0.1/phpMyAdmin/sql.php?db=dic&table=tb2&token=3916e134a016442e0d1dbd95d848efd0&pos=0&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&sql_query=DELETE+FROM+%60tb2%60+WHERE+%60tb2%60.%6 0idF%60+%3D+12+LIMIT+1&zero_rows=The+row+has+been+deleted&goto=sql.php%3Fdb%3Ddic%26table%3Dtb2%26token%3D39 16e134a016442e0d1dbd95d848efd0%26pos%3D0%26session _max_rows%3D30%26disp_direction%3Dhorizontal%26rep eat_cells%3D100%26dontlimitchars%3D0%26sql_query%3 DSELECT%2B%252A%2BFROM%2B%2560tb2%2560%26zero_rows %3DThe%2Brow%2Bhas%2Bbeen%2Bdeleted%26goto%3Dtbl_p roperties_structure.php) 12 ابیبیبی نیببی http://127.0.0.1/phpMyAdmin/themes/original/img/b_edit.png (http://127.0.0.1/phpMyAdmin/tbl_change.php?db=dic&table=tb2&token=3916e134a016442e0d1dbd95d848efd0&pos=0&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&primary_key=+%60tb2%60.%60idF%60+%3D+10&sql_query=SELECT+%2A+FROM+%60tb2%60&goto=sql.php) http://127.0.0.1/phpMyAdmin/themes/original/img/b_drop.png (http://127.0.0.1/phpMyAdmin/sql.php?db=dic&table=tb2&token=3916e134a016442e0d1dbd95d848efd0&pos=0&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&sql_query=DELETE+FROM+%60tb2%60+WHERE+%60tb2%60.%6 0idF%60+%3D+10+LIMIT+1&zero_rows=The+row+has+been+deleted&goto=sql.php%3Fdb%3Ddic%26table%3Dtb2%26token%3D39 16e134a016442e0d1dbd95d848efd0%26pos%3D0%26session _max_rows%3D30%26disp_direction%3Dhorizontal%26rep eat_cells%3D100%26dontlimitchars%3D0%26sql_query%3 DSELECT%2B%252A%2BFROM%2B%2560tb2%2560%26zero_rows %3DThe%2Brow%2Bhas%2Bbeen%2Bdeleted%26goto%3Dtbl_p roperties_structure.php) 10 چیییییییییییث http://127.0.0.1/phpMyAdmin/themes/original/img/b_edit.png (http://127.0.0.1/phpMyAdmin/tbl_change.php?db=dic&table=tb2&token=3916e134a016442e0d1dbd95d848efd0&pos=0&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&primary_key=+%60tb2%60.%60idF%60+%3D+9&sql_query=SELECT+%2A+FROM+%60tb2%60&goto=sql.php) http://127.0.0.1/phpMyAdmin/themes/original/img/b_drop.png (http://127.0.0.1/phpMyAdmin/sql.php?db=dic&table=tb2&token=3916e134a016442e0d1dbd95d848efd0&pos=0&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&sql_query=DELETE+FROM+%60tb2%60+WHERE+%60tb2%60.%6 0idF%60+%3D+9+LIMIT+1&zero_rows=The+row+has+been+deleted&goto=sql.php%3Fdb%3Ddic%26table%3Dtb2%26token%3D39 16e134a016442e0d1dbd95d848efd0%26pos%3D0%26session _max_rows%3D30%26disp_direction%3Dhorizontal%26rep eat_cells%3D100%26dontlimitchars%3D0%26sql_query%3 DSELECT%2B%252A%2BFROM%2B%2560tb2%2560%26zero_rows %3DThe%2Brow%2Bhas%2Bbeen%2Bdeleted%26goto%3Dtbl_p roperties_structure.php) 9 چطوری http://127.0.0.1/phpMyAdmin/themes/original/img/b_edit.png (http://127.0.0.1/phpMyAdmin/tbl_change.php?db=dic&table=tb2&token=3916e134a016442e0d1dbd95d848efd0&pos=0&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&primary_key=+%60tb2%60.%60idF%60+%3D+15&sql_query=SELECT+%2A+FROM+%60tb2%60&goto=sql.php) http://127.0.0.1/phpMyAdmin/themes/original/img/b_drop.png (http://127.0.0.1/phpMyAdmin/sql.php?db=dic&table=tb2&token=3916e134a016442e0d1dbd95d848efd0&pos=0&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&sql_query=DELETE+FROM+%60tb2%60+WHERE+%60tb2%60.%6 0idF%60+%3D+15+LIMIT+1&zero_rows=The+row+has+been+deleted&goto=sql.php%3Fdb%3Ddic%26table%3Dtb2%26token%3D39 16e134a016442e0d1dbd95d848efd0%26pos%3D0%26session _max_rows%3D30%26disp_direction%3Dhorizontal%26rep eat_cells%3D100%26dontlimitchars%3D0%26sql_query%3 DSELECT%2B%252A%2BFROM%2B%2560tb2%2560%26zero_rows %3DThe%2Brow%2Bhas%2Bbeen%2Bdeleted%26goto%3Dtbl_p roperties_structure.php) 15 تابرتبرا