MySQL Bugs: #9146: Some character in UTF-8 missed

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:	Windows (win 2003 server Enterprise Editi)
Assigned to:		CPU Architecture:	Any

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 "&#1601;" 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("&#1605;&#1578;&#1575;&#1587;&#1601;&#1575;&#1606;&#1607;") "

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.