Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL SELECT ORDER BY, W and V
Message
From
12/10/2010 15:10:03
 
 
To
12/10/2010 09:39:26
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01484718
Message ID:
01485069
Views:
44
>I have no idea what that is. Actually I had to switch back to SWEFIN collation because the diacritics are sorted differently i GERMAN. SWEFIN behaves like SQL-Server collate Finnish_Swedish_CI_AI. Still it doesn't separate V and W. I would like it to behave like SQL_SwedishStd_Pref_CP1_CI_AS.

Try out the collate sequences
UNIQWT && Unique Weight, soory for the mistype earlier
GENERAL

and perhaps play a bit with the codepages used -
I just wonder, why that such a mistake would not have surfaced before.

regards

thomas
Previous
Reply
Map
View

Click here to load this message in the networking platform