I took a look at your site (YazdIndustry.com). Very impressive. Do you require sorting when displaying the results of a search? I know MySQL does not sometimes, for example, distinguish between letters with diactritics and the ones without, like Ā and A or ā and a.  What I have done to make sure MySQL does not make these kinds of mistakes is to save the Persian words in 2 different ways. One using the 1256 format and the other using a regular font. This way when you do a search for a word you will have to check 2 entries if needed. For sorting you could use the font entries since they are mostly in ASCII characters.
 
All these problems with the Arabic script makes me a believer in changing our alphabet to a Latin-based one and getting rid of all these unnecessary headaches :-)
 
Dr. Z.
----- Original Message -----
To: FK
Sent: Thursday, November 07, 2002 6:22 PM
Subject: Re: [farsiweb]unicode fields in database

No it is not. this is not PHP problem, I think it is MySQL problem that not support unicode. You can write a simple code to select the rows but never you will get soreted result in right order :-(
I did not test it on Windows Server. But I test it with ARABIC and UNICODE encoding both. and failed to get what I want
:((
 
Bests,
Sadeq Naqashzade
[EMAIL PROTECTED]
 
----- Original Message -----
From: FK
Sent: Sunday, November 10, 2002 8:20 AM
Subject: Re: [farsiweb]unicode fields in database

I guess for sorting you would just need to write a few lines of code. It would not be too difficult.
----- Original Message -----
To: Zurvan
Sent: Thursday, November 07, 2002 5:27 PM
Subject: Re: [farsiweb]unicode fields in database

Salaam,
What about persian sort? is it correct? I use Unicode. I can do search and show texts using MySQL but my problem in correct sort. You can see the example in www.YazdIndustry.com that is a directory of Yazd Industrials that is under construction now but some things is ready.
 
Regards
Sadeq
----- Original Message -----
From: Zurvan
Sent: Saturday, November 09, 2002 10:56 PM
Subject: Re: [farsiweb]unicode fields in database

Hamid Rezāye gerāmi:
 
Man bā "unicode" kār nakardeam vali tavānestam bā bekār bordane:
 
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=windows-1256">
 
dar safheye xod, bā tāyp kardan be Pārsi az bānke "MYSQL" estefāde konam. In kār besyār sāde anjām šod. Mitavānid barāye mesāl be safheye zir negāh bekonid:
 
 
Sepāsmandam,
 
Dr. Zurvān
IL&S
 

Reply via email to