Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Index on char binary
Message
De
10/09/2004 10:56:39
Dragan Nedeljkovich (En ligne)
Now officially retired
Zrenjanin, Serbia
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00940995
Message ID:
00941054
Vues:
15
>Hi.
>I have index on char binary fields in two tables which i link with relation. The relation works only with the code page under which the index was created. So NOCPCONVERT is neglected when an index is created. This seems illogical... to me at least.
>(VFP 8.0)

Ever since FPD2.6, when codepages and collating sequences were introduced, it remained as it was then: for indexing on anything binary, Set Collate "Machine". Any other collating sequence will create trouble, because it maps characters and character combinations into byte pairs, so you never really know what maps into what, and the mapping isn't one-to-one. Other collating sequences map the uppercase and lowercase characters into same pairs, which makes different strings look the same when mapped.

So if your binary tag has any other collating sequence but Machine, you simply can't use it as a target in a relation. Just drop that tag and re-create it in Machine sequence.

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform