Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.lang.clipper.visual-objects > #12485

Re: Collation problem

From Johan Nel <johan.nel@xsinet.co.za>
Newsgroups comp.lang.clipper.visual-objects
Subject Re: Collation problem
Date 2019-05-10 13:36 +0200
Organization A noiseless patient Spider
Message-ID <qb3nnj$df7$1@dont-email.me> (permalink)
References <qn7adepmhk5d3mcbspf2c19bss43bjem7n@4ax.com> <qb3g1q$4ch$1@dont-email.me> <rekadedgpgrpct8e2pqc2tksm082nqpdpg@4ax.com>

Show all headers | View raw


Hi Dick,

Ok I am not an expert on it, but are there not a server setting on their 
side that changes the Collatioon to the DBFCDX in Ansi and not Clipper 
collation format?

On 2019/05/10 12:30, D.J.W. van Kooten wrote:
> Replying on message of Fri, 10 May 2019 11:25:14 +0200 from Johan Nel:
>
>
>   Hello Johan Nel
>
>> You sure there was not a "Reindex" task outside your application that
>> happened?  Remember the difference between Clipper and Ansi/Windows
>> Collation will have the "_" be handled as First/Last in sorting, hence
>> if your application assume it is the wrong one, you will end up with
>> some "keys" not found.
> Thanks for reminding me to the differences between those 2 collations.
>
> Yes I am sure about not reindexing but the weirdest thing is that when
> I use e.g. dbvMax (or my applications of course) to locate
> FX_SOMETHING it will be found. When I send the same DBF+CDX to the
> server of my client it is NOT found unless I reindex in dbMax with
> Clipper DOS Collation.
>
> It should find the key in both cases even though the collation would
> cause a different presentation order. And it should certainly not stop
> finding it when I transfer it (using Explorer \\tsclient) to their RD
> accessible server...
>
>
> Dick
-- 
*Johan Nel*
FOX member : Friend(s) of XSharp
X# Website : https://xsharp.info
X# Forums : https://xsharp.info
George, South Africa

Back to comp.lang.clipper.visual-objects | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread


Thread

Collation problem D.J.W. van Kooten <vankooten@removethis.ic2.com> - 2019-05-10 09:05 +0200
  Re: Collation problem Johan Nel <johan.nel@xsinet.co.za> - 2019-05-10 11:25 +0200
    Re: Collation problem D.J.W. van Kooten <vankooten@removethis.ic2.com> - 2019-05-10 12:30 +0200
      Re: Collation problem Johan Nel <johan.nel@xsinet.co.za> - 2019-05-10 13:36 +0200
        Re: Collation problem D.J.W. van Kooten <vankooten@removethis.ic2.com> - 2019-05-10 16:56 +0200
          Re: Collation problem "Jamal" <noooospam@example.com> - 2019-05-11 04:32 -0400

csiph-web