Path: csiph.com!eternal-september.org!feeder.eternal-september.org!news.eternal-september.org!.POSTED!not-for-mail From: James Martin Newsgroups: comp.lang.clipper.visual-objects Subject: Re: Wrong Sort Order of Index Date: Fri, 25 Aug 2017 09:16:58 -0400 Organization: A noiseless patient Spider Lines: 97 Message-ID: References: Mime-Version: 1.0 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 8bit Injection-Date: Fri, 25 Aug 2017 13:12:41 -0000 (UTC) Injection-Info: mx02.eternal-september.org; posting-host="ff8ca9bb7adb52d039fe0c400b02b5d4"; logging-data="19189"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1+ZM087TpVW5bpvnG2na7Ud" User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101 Thunderbird/52.2.1 In-Reply-To: Content-Language: en-US Cancel-Lock: sha1:ioFNR1HuCmfVlzn5sp3SYa44NMg= Xref: csiph.com comp.lang.clipper.visual-objects:10939 But space is ascii 32 and dash is ascii 45. James On 2017-08-25 08:30 AM, Michael Hagl wrote: > Hi Karl-Heinz, > > >> #Windows >> >> aaa-bab >> aaa-bbc >> aaa-bcb >> aaa >> abc >> abd >> >> But there might be another problem.No matter if the index is created using >> #clipper or #windows a seek shouldn´t fail. Maybe later on, after creating >> the index, Jürgen switches from #windows to #clipper ? Didn´t try that, >> but >> i guess that a seek fails - maybe not always - in such cases ? >> > > At this sorting order a softseek for "aaa" and find aaa-bab is IMHO correct. > The fist occurence of "aaa" has been found. I think, this sorting order is > wrong. This collation sorts the "-" before the Space > > Michael Hagl > > > "Karl-Heinz" schrieb im Newsbeitrag > news:f0ae74F2dqjU1@mid.individual.net... >> Hi Michael, >> >>> I have do some tests: (ADS-12, OEM- und ANSI-Character Set is setting to >>> GERMAN),l but xHarbour >> >> i made a small VO-Test. Depending on that code i get these results: >> >> FUNCTION Start() >> LOCAL oDB AS DBServer >> LOCAL cPfad AS STRING >> >> >> // makes no differences if sortorder.dbf ist a OEM-Dbf or not >> >> // SetCollation ( #windows ) >> SetCollation ( #clipper ) >> >> RddSetDefault ( "DBFCDX" ) >> >> cPfad := "D:\test\" >> >> >> IF File ( cPfad + "SOrtorder.cdx" ) >> FErase ( cPfad + "SOrtorder.cdx" ) >> >> ENDIF >> >> oDB:= DbServer { cPfad + "SOrtorder.dbf" } >> oDB:Createorder ( "OrderID", cPfad + "SOrtorder.cdx", "Upper(ID)" ) >> >> oDB:Close() >> >> RETURN NIL >> >> >> #clipper >> >> aaa >> aaa-bab >> aaa-bbc >> aaa-bcb >> abc >> abd >> >> >> #Windows >> >> aaa-bab >> aaa-bbc >> aaa-bcb >> aaa >> abc >> abd >> >> But there might be another problem.No matter if the index is created using >> #clipper or #windows a seek shouldn´t fail. Maybe later on, after creating >> the index, Jürgen switches from #windows to #clipper ? Didn´t try that, >> but >> i guess that a seek fails - maybe not always - in such cases ? >> >> regards >> Karl-Heinz > >