|
>From the DDS manual: 00010A ALTSEQ(TABLELIB/TABLE1) 00020A R RECORD1 PFILE (PF1) 00030A : 00040A : 00050A : 00060A NAME 20 00070A : 00080A : 00090A K NAME Only instead of TABLELIB/TABLE1 use QSYSTRNTBL and it will build the keys as if they were stored in the file all uppercase. Great for logical files. doug@netserv.ouac.on.ca on 05/27/99 02:13:51 PM Please respond to MIDRANGE-L@midrange.com@Internet To: midrange-l@midrange.com@Internet cc: Fax to: Subject: String Searching Hi, We stores people's names in our database in mixed upper-/lower- case, and mixed english/french characters. We've gradually been experiencing little problems now with name searches, alphabetically sorted lists, etc., since the characters get sorted {a,b, ..., z, A, B, ..., Z} and english letters like "e" and "a" not being equal to "e`" and "a`" (i.e. letter with french accent above). So, names like "de Silva" do not sort with the rest of the "D's", "von ..." do not sort with the rest of the "V's", etc. We've tossed around a couple of solutions like: 1) storing another version of the name fields in strict upper-case/english only, and using that for searching, then displaying the other version to users 2) building temporary files containing the same as in 1) as needed 3) translating the data in the input records and search arguments on the fly as they're read from the file (which may mean reading the complete file in some applications, or at least more reads than just doing a basic "<search argument> SETLL <file> and <search argument> READE <file>" (we're RPG users <grin>). Does anyone have any other tricks or solutions that you'd be willing to share? Thanks in advance, Doug -------------------------------------------------------------------------- Doug Holmes Senior Programmer Ontario Universities' Application Centre P.O. Box 1328, 650 Woodlawn Road West Guelph ON, CANADA N1H 7P4 TELEPHONE: (519)823-1940, x 224 FAX: (519)823-5232 www.ouac.on.ca -------------------------------------------------------------------------- +--- | This is the Midrange System Mailing List! | To submit a new message, send your mail to MIDRANGE-L@midrange.com. | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com. | To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com. | Questions should be directed to the list owner/operator: david@midrange.com +--- +--- | This is the Midrange System Mailing List! | To submit a new message, send your mail to MIDRANGE-L@midrange.com. | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com. | To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com. | Questions should be directed to the list owner/operator: david@midrange.com +---
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.