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 -
From:
Naqashzade, Sadeq
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
To: Naqashzade, Sadeq ; [EMAIL PROTECTED]
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 -
From:
Naqashzade,
Sadeq
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
To: [EMAIL PROTECTED] ; [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
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:
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:
http://iranianlanguages.com/dictionary.php?eng-per
Sepâsmandam,
Dr. Zurvân
IL&S