Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
BINTOC function doesn't sort numeric data correctly
Message
 
 
To
05/12/2001 06:35:47
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00589393
Message ID:
00589807
Views:
34
Thanks, Hilmar.

>>However, I should not use UPPER function with BINTOC. So, it's my error and I will now be more careful.
>>
>>Thanks to you and Cetin.
>
>Nadya,
>
>For your reference, there is one other thing thou shalt not do with indices that include BINTOC(): use collating sequence other than "MACHINE". This will implicitly convert to UPPER(), and do some other things, too.
>
>Collating sequences are sometimes used for non-English applications, to ensure correct sorting of characters with diacritical marks (accents, etc.).
>
>Regards, Hilmar.
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform