Hi, Speaking of indexing, some database servers e.g. Oracle 8i, 9i can build index on user defined functions (whether it is a C funtion or PL/SQL). It is called FBI ! (Function Based Index)
-Amir --- Hamidreza Younesy Aghdam <[EMAIL PROTECTED]> wrote: > Hi, > As I've told before, we can define User Defined > functions, in SQL Server. So we may have a function > with a simple hash table, mapping the characters into > our defined sort order. Then we can simply use the > function in the "ORDER BY" clause; e.g. (SELECT * FROM > PERSONAL ORDER BY CorrectSort(lastname)" > It is also possible to use triggers to store the > converted data (instead or together with the real > data), if we have a large amount of records. Using the > convert function in the ORDER BY clause, will be very > slow specially because we do not use the Indexes. > As I talked with some of the committee members, they > told, they are going to publish a semi-standard for > Farsi sorting. I think after having such a thing, > someone may write a general function to be used by > all. > > > > > ===== > ....../--/| /--/|................................... > ...../ /_// / /.................................. > ..../ / /amidreza Younesy Aghdam > .../ ___ / / Emails : [EMAIL PROTECTED] > ../ /|_/ / / [EMAIL PROTECTED] > ./__/ //__/ /omepage:http://ce.sharif.edu/~younesy > .|__|/ |__|/....................................... > > __________________________________________________ > Do You Yahoo!? > Sign up for SBC Yahoo! Dial - First Month Free > http://sbc.yahoo.com > _______________________________________________ > FarsiWeb mailing list > [EMAIL PROTECTED] > http://lists.sharif.edu/mailman/listinfo/farsiweb __________________________________________________ Do You Yahoo!? Sign up for SBC Yahoo! Dial - First Month Free http://sbc.yahoo.com _______________________________________________ FarsiWeb mailing list [EMAIL PROTECTED] http://lists.sharif.edu/mailman/listinfo/farsiweb
