Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
BIG BUG: Index not support binary strings
Message
De
14/11/2003 09:52:30
 
 
À
14/11/2003 09:40:46
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00849781
Message ID:
00849869
Vues:
25
Hi Alan,

-----
Well, maybe, but if you want to use binary data in your table, it seems to me that using a binary index might not be so absurd.

My english is bad, but example is clear ( you have try it ? ):
Except special situation USE "General" collate with binary index is a error.

I put another example:
CLEAR
Create Cursor test(F1 C(2))

Index On F1  tag Num COLLATE "general"

Insert into test(F1) values ('A ')
Insert into test(F1) values ('A'+CHR(0))
Insert into test(F1) values ('A'+CHR(1))
Insert into test(F1) values ('A'+CHR(2))
Insert into test(F1) values ('A'+CHR(3))

COUNT FOR F1=='A'+CHR(0)
? _TALLY && this return 4 and is correct
Alan
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform