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 image 1 shown result when type keyborad

and image 2 shown result in same database when copy , paste search term

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

Popular posts from this blog

Detect support for Shoutcast ICY MP3 without navigator.userAgent in Firefox? -

web - SVG not rendering properly in Firefox -

java - JavaFX 2 slider labelFormatter not being used -