Re: [farsiweb]unicode fields in database
> 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 :-) It is much easier to make the changes to the software to add the sorting rules of a new coding than it would be to retrain 70M+ people. BTW, what you suggest would transfer the problem somewhere else. So many of the words in Farsi are from Arabic base that in order to preserve the etymology of the words, you are forced to devise a one-to-one mapping of chars in Arabic glyph form to Latin form. So now you have the sorting problem somewhere else. I don't believe changing the char set would offer you any advantages either. I don't know if anyone would say that the state of comp. sci. or automation is markedly better in Turkey vs. Iran, for example. Turkey adopted the Latin char set some 70 years ago. It is interesting to observe, when visiting historical sites in Turkey, that most Turks can't read the poetry that is inscribed in stone in so many mosques and palaces. Sad indeed. Not adopting a Latin char set has not hurt Japan. -Fariborz ___ FarsiWeb mailing list [EMAIL PROTECTED] http://lists.sharif.edu/mailman/listinfo/farsiweb
Re: [farsiweb]unicode fields in database
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
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
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
Re: [farsiweb]SOS
On Fri, 8 Nov 2002, Mohsen Pahlevanzadeh wrote: > But i don't know that how type farsi in KDE or GNOME. Use Red Hat 8.0's KDE and GNOME. GNOME's 'gedit' support Persian, and also some of the KDE text editors (I can't remember which do). The Persian keyboard layout is also included in Red Hat 8.0 if you install it, but you may need to install fonts of your own, which you may get from your Windows fonts directory, or download some from: http://corefonts.sourceforge.net/ I also have a post about enabling the Persian keyboard in Red Hat 7.3's KDE at: http://lists.sharif.edu/pipermail/farsikde/2002-June/000369.html But I don't know if exactly the same procedure will work with Red Hat 8.0. roozbeh ___ FarsiWeb mailing list [EMAIL PROTECTED] http://lists.sharif.edu/mailman/listinfo/farsiweb
Re: [farsiweb]unicode fields in database
On Fri, 8 Nov 2002, Nasiri2 wrote: > Do you use Persian unicode fields in any database? How do you sort these > fields while the letters "Gaf,Cheh,Peh, and Zheh" are not in correct > order? Your database or your programming language should provide the sorting mechanism, or you should implement sorting yourself (as a database engine plug-in if it supports it, or in the programming language if it doesn't). We already have solutions for C, PHP, and PostgreSQL, but all are Linux-only, or possibly Cygwin (port of GNU tools to Windows). > How do you represent these fields in HTML or ASP pages > (converting them to HTML entity code dynamically, saving their entity > codes, or whatever else)? As far as I can tell, you HTML doesn't have any notion of fields. If you mean the letters Peh, Gaf, Farsi Yeh, etc, they can be referenced in HTML pages as "&#x"+hexcode+";". Farsi Yeh becomes "ی", for example. roozbeh ___ FarsiWeb mailing list [EMAIL PROTECTED] http://lists.sharif.edu/mailman/listinfo/farsiweb
[farsiweb]a file
Hi Mohsen, I forgot to attach this file, copy it with the previous HTML file I sent for you. Bye. Hamid farsi.js Description: JavaScript source
[farsiweb]Re: FarsiWeb digest, Vol 1 #187 - 1 msg
Hi mohsen, Don't cry :) , use my simple tool for writing Unicode text. Bye, Hamid Title: Farsi Unicode Character set Homepage Text to HTML entity code Convertor Written by : Hamid Reza Nasiri , AEOI Data Processing Center. تبدیل متن فارسی به رشته کد یونی کد : Press Alt+Shift to change language input mode . Persian Segment of Unicode Character Set Table Reference : The Unicode Standard 3.0 CodeNesfMitra CodeNesfMitra Greek & Coptic Segment of Unicode Character Set Table Reference : The Unicode Standard 3.0 Code Glif Code Glif
Re: [farsiweb]unicode fields in database
I have posted something about Sorting Persian text in PostgreSQL, search for it in the archives. behdad On Fri, 8 Nov 2002, Nasiri2 wrote: > Hello dears, > > Do you use Persian unicode fields in any database? How do you > sort these fields while the letters "Gaf,Cheh,Peh, and Zheh" > are not in correct order? How do you represent these fields in > HTML or ASP pages (converting them to HTML entity code > dynamically, saving their entity codes, or whatever else)? > > Thank you for any suggestion, > > Hamid Reza Nasiri > -- Behdad Esfahbod 18 Aban 1381, 2002 Nov 9 http://behdad.org/ [Finger for Geek Code] #define is_persian_leap(y) y)-474)%2820+2820)%2820*31%128<31) ___ FarsiWeb mailing list [EMAIL PROTECTED] http://lists.sharif.edu/mailman/listinfo/farsiweb
[farsiweb]unicode fields in database
Hello dears, Do you use Persian unicode fields in any database? How do you sort these fields while the letters "Gaf,Cheh,Peh, and Zheh" are not in correct order? How do you represent these fields in HTML or ASP pages (converting them to HTML entity code dynamically, saving their entity codes, or whatever else)? Thank you for any suggestion, Hamid Reza Nasiri
