Hi, Nice idea, this is the same as what I'm going to implement for postgresql, BTW, does it support PE, CHE, ... too?
On Mon, 24 Jun 2002, Hamidreza Younesy Aghdam wrote: > Hi, > > Fortunately I found some kind of solution for the > sorting problem, just after sending the mail. I was > mixied with this problem for more than a week, but i > don't know why I must find the answer after sending > the question (beleive me)! May be some kind of holy > spirit on this mailing list ;) > > As I had talked personaly to some of the friends in > this list before and we didn't find a reasonable > solution, I hope this may be useful for some of you: > > 1. create a userdefined function: > > CREATE FUNCTION CorrectSort (@field char(100)) > RETURNS char(100) > AS > BEGIN > RETURN REPLACE(REPLACE((REPLACE(REPLACE(@field, > 'Heh','$' ),'Waw','Heh')),'$','Waw'),'Keheh','Kaf') > END > > use the exact farsi characted instead of the "Heh", > "Waw", "Keheh", "Kaf". use any dummy char instead of > "$") > > then use this function in the order by clase: > SELECT * FROM Personal > ORDER BY CorrectSort(Lastname), CorrectSort(Firstname) > > ---------------------------------------------------- > > BTW, I am still looking for some solution for > substituting the Keheh with Kaf on data entry. > > ===== > ....../--/| /--/|................................... > ...../ /_// / /.................................. > ..../ / /amidreza Younesy Aghdam > .../ ___ / / Emails : [EMAIL PROTECTED] > ../ /|_/ / / [EMAIL PROTECTED] > ./__/ //__/ /omepage:http://ce.sharif.edu/~younesy > .|__|/ |__|/....................................... > > __________________________________________________ > Do You Yahoo!? > Yahoo! - Official partner of 2002 FIFA World Cup > http://fifaworldcup.yahoo.com > _______________________________________________ > FarsiWeb mailing list > [EMAIL PROTECTED] > http://lists.sharif.edu/mailman/listinfo/farsiweb > -- Behdad Esfahbod 4 Tir 1381, 2002 Jun 25 http://behdad.org/ [Finger for Geek Code] Debug is human, de-fix divine. _______________________________________________ FarsiWeb mailing list [EMAIL PROTECTED] http://lists.sharif.edu/mailman/listinfo/farsiweb
