php - search in mysql with utf8 encoding -
im working on project in arabic language need search in database of utf-8 words table collation in ' utf8' , mysql connection type utf8 too.
now when type word (for example 'ﺗﻮﺿﻴﺢ') in query string keyboard cant find of results when try copy , paste phpmyadmin find of results!!
image 1 shown result when type keyborad
and image 2 shown result in same database when copy , paste search term
question problem , how can type search term find of results...
ps: 1)i have attache both post content first copy , paste text , second when typing text
i found differentiation between post queries
when copy text :
is_js_confirmed=0&db=digidoc&table=docs_pages&token=43847946c2deb1885e9c0f9ed97839a3&pos=0&goto=tbl_sql.php&message_to_show=your+sql+query+has+been+executed+successfully&prev_sql_query=select+*+from+%60docs_pages%60+where+%60page_content%60+like+'%25%ef%ba%97%ef%bb%ae%ef%ba%bf%ef%bb%b4%ef%ba%a2%25'&sql_query=select+*+from+%60docs_pages%60+where+%60page_content%60+like+'%25%ef%ba%97%ef%bb%ae%ef%ba%bf%ef%bb%b4%ef%ba%a2%25'&bkm_label=&sql_delimiter=%3b&show_query=1&ajax_request=true
and when type :
is_js_confirmed=0&db=digidoc&table=docs_pages&token=43847946c2deb1885e9c0f9ed97839a3&pos=0&goto=tbl_sql.php&message_to_show=your+sql+query+has+been+executed+successfully&prev_sql_query=select+*+from+%60docs_pages%60+where+%60page_content%60+like+'%25%2525%25ef%25ba%2597%25ef%25bb%25ae%25ef%25ba%25bf%25ef%25bb%25b4%25ef%25ba%25a2%2525%25'&sql_query=select+*+from+%60docs_pages%60+where+%60page_content%60+like+'%d8%aa%d9%88%d8%b6%db%8c%d8%ad'&bkm_label=&sql_delimiter=%3b&show_query=1&ajax_request=true
but why!? same chars in same browser!
Comments
Post a Comment