MySQL Bugs: #16519: The problem with char-set in perisan ( farsi ) language with <F> ف

Bug #16519	The problem with char-set in perisan ( farsi ) language with <F> ف
Submitted:	15 Jan 2006 20:02	Modified:	16 Feb 2006 13:12
Reporter:	Soroosh Karimi	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Administrator	Severity:	S1 (Critical)
Version:	4.1	OS:	Linux (Linux)
Assigned to:		CPU Architecture:	Any

Description:
Hello 
My name is Soroosh Karimi . I am a web developer and web designer and host + domain porvider . 
I use Mysql and Phpmyadmin for my web hosting databases , and at first I thanks of your best services . 
But lately I got into a trouble and no one can solve it , so I want to ask you to help me , please .
My problem is that after transfering a web site and restoring the database I got in the problem that the character <F> ف ( In Farsi Language )
changes to a character like ت <T> ( In Farsi Language ) and it's making me crazy . 
So I asked many persons and they told me that because of having Mysql version 4.1 it happens .
My native language is Farsi and we have that problem . 
Please if you have any good approach to solve this problem , let me know . 
Tell me what to do and help me . please , please  , please .
You can see the problem here : 
www.abadgareyazd.org 
and 
www.sorooshk.com/s 
Thank You for your Cooperation . 
And excuse me if my english is not as good as english native speakers .
Soroosh Karimi 
www.sorooshk.com

How to repeat:
just as i told above

please help me

Soroosh,
1) what makes you believe it's mysql administrator problem? Mysql adminstrator is actually GUI tool for mysql, I dont see you use mysql administrator
2) I want to separate web and mysql problems. Did you try to insert that persian 'F' into database from mysql console tool? What is table definitions? Do you use 'set names' command immediatelly after connection to mysql?

Hi Soroosh,
I am having the same problem with mySQL 4.1.13-standard.

I am using on my Localhost MySQL 5.0.15-nt and made a db with the Collations "utf8_persian_ci". Everything works fine.
But after exporting it to an sql file and uploading it on the Online server which runs the4.1.13 version all my " ف " characters look like " ?? ".

It is possible though to change the Collations to latin1_general_ci and retype the whole db again. It worked but if you have lots of db entries allready made, you should consider converting the charcters from utf8 to Latin1.
And i am still waiting to find a way on how to do that!

If anybody knows a way how to convert utf8 to latin within the windows system, let us know and save us!

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".