Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Index on char binary
Message
From
10/09/2004 08:52:46
 
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00940995
Message ID:
00941003
Views:
21
>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)
>All the best.

hi Kamil,

I think that it is the collating sequence of the index that is important. For binary fields the one to use is 'Machine'. Any other will cause trouble (Kamil = KAMIL = kamil)

So, you may have to drop the indexes and recreate them with Machine collating sequence
Gregory
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform