You can change your charset by adding a line in your mysql configuration file like this.
default-character-set = cp1256
Here cp1256 means that mysql will use Windows Arabic character set. I don't know the difference between farsi and arabic charsets. And also I don't know if mysql has a farsi charset support. But if you are able to use arabic charset you can set your charset to cp1256 like above. You can also take a look at http://www.mysql.com/doc/en/Charset-charsets.html page. Here you can get info about mysql charsets.
[EMAIL PROTECTED] wrote:
I use unicode to store farsi data in mysql database but I have problems sorting it using ORDERBY command...(ORDER BY does'nt work properly)
I don't know what to do .....
1---)pleases help me if there is any solution for me to define a charset in the order that I want .
2---) how can I replace the default charset of mysql (latin1) with this new charset.
3---) please help me if there is any other solution like writing a functioin (how should I write a functioin).
thanx for your helps...
--------------------------------- Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month!
--
Veysel Harun Sahin [EMAIL PROTECTED]
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
