Hi, Mohammad
I have replied to this on Delphi_programmer Group. Here is my response again. My problem was similar in that I wanted to sort records ignoring case, marks and accents (for example E,,?,?,E,E,E,E,e,e,e,e,?,?,?,?,?,?,?,?,e,e,e,e and e are equivalent for the sort). The method was to create a sort key field in a single case without accents and to sort on that field. An example would be: ARRETE CAFE ROLE Another problem we have is that surnames starting with Mc or Mac are treated the same. So, for example, all these names are equivalent: MacDonald McDonald Macdonald This new field must be in the database and cannot be created at runtime. It makes the database larger, but it will solve your problem. Bobby Clarke -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of ekhorasan Sent: 26 June 2005 07:19 To: [email protected] Subject: [delphi-en] paradox database Hi i have a question about paradox database in delphi for foreign language data. i have a database which have farsi language data.now i can sort it in arabic alphabetic order however 4 alphabet of farsi (persian),gaf,pe,zhe.che is not ordered in this case *how can i sort it according to farsi alphabetic? *is there any BDE language driver for foreign languages specially farsi? best regards mohammad ----------------------------------------------------- Home page: http://groups.yahoo.com/group/delphi-en/ To unsubscribe: [EMAIL PROTECTED] ---------------------------------------------------------------------------- -- YAHOO! GROUPS LINKS a.. Visit your group "delphi-en" on the web. b.. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. ---------------------------------------------------------------------------- -- [Non-text portions of this message have been removed] ----------------------------------------------------- Home page: http://groups.yahoo.com/group/delphi-en/ To unsubscribe: [EMAIL PROTECTED] Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/delphi-en/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
