on 8/31/01 22:24, jda at jda /at/ his .DOT com wrote:
> That does seem to be the problem. OK, I can avoid this, but I only
> implemented this scheme (the method) so that I could search a db and
> get a case-insensitive sort of the data (so that "Z" doesn't sort
> before "a").
John, common mistake.
Just think, how you can forse DBMS sort field indexed by words?
Let record has "aaa kkk zzz". Where this record should go, to "a" or "z"?
You see ?
and case here is not an issue.
If you want do case-insensitive SQL ORDER BY
then you have made all almost correctly. Just remove flag index by words.
And you will be able sort records case-insensitive.
But you will loose ability search by words.
> Will a case-insensitive SQL ORDER BY be part of the new
> SQL parser? If so, I can wait. If not, what other workaround is there
> (I need INDEX BY WORDS, because the nonindexed search is too slow
> with lots of data)?
Yes, this is 2 excluding things.
At least for now, because I do not have idea how implement them both in the
same time.
Only way to have one more index.
One for search and one for sort.
--
Best regards,
Ruslan Zasukhin
-------------------------
Paradigma.
e-mail: ruslan@paradigmasoft.com
web : http://www.paradigmasoft.com
To subscribe to the Valentina mail list
send a letter to valentina-on /at/ lists .DOT macserve.net
©2001 Ruslan Zasukhin |
