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.
|
- [farsiweb]unicode fields in database Nasiri2
- Re: [farsiweb]unicode fields in database Behdad Esfahbod
- Re: [farsiweb]unicode fields in database Roozbeh Pournader
- Re: [farsiweb]unicode fields in database Zurvan
- Re: [farsiweb]unicode fields in database Skip Tavakkolian
- Re: [farsiweb]unicode fields in database Roozbeh Pournader
- Re: [farsiweb]unicode fields in database Jalal Abedinejad
- Re: [farsiweb]unicode fields in database Skip Tavakkolian