Bug #9146 Some character in UTF-8 missed
Submitted: 12 Mar 2005 17:30 Modified: 7 Apr 2005 6:54
Reporter: Reza Sadeghi Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server Severity:S1 (Critical)
Version: OS:Microsoft Windows (win 2003 server Enterprise Editi)
Assigned to: CPU Architecture:Any

[12 Mar 2005 17:30] Reza Sadeghi
Description:
I Use Mysql v. 4.1.7 and php v4.3.10 and try to insert some data in utf-8 format to tables with utf8 charset in PERSIAN language, But a character "ف" when insert in table convert to undifined character in UTF-8 ,and when i show it in web page i see incorrect Symbol "Squer" in my text ,
Best regards

How to repeat:
Use this code:
" Insert into TABLENAME ("FieldName") value("متاسفانه") "
[23 Mar 2005 17:07] Jose Alejandro Guizar
I'm positive that mysql's internal charset conversion engine (or whatever it is) has bugs, and somehow it's enconding your input internally. Since you don't want that to happen, you have to properly configure the character_set_* variables; I made a post with more information, see bug #9091 for a possible solution to your problem.