Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
BIG BUG: Index not support binary strings
Message
From
14/11/2003 09:52:30
 
 
To
14/11/2003 09:40:46
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00849781
Message ID:
00849869
Views:
24
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform