Reported By: Rolf Frei Reported On: 3/4/2001 For: Version 2.07 Build 1
# 733Default Ordering of Canned Result Sets Incorrect for Non-ANSI Standard Source Tables The following query uses ANSII ordering. That means, any lower chars are behind all upper chars. The field Subject has no index so the result is canned.
The output is:
Ansdfg
Zskdkjfs
akdjk
bjshdkd
The table language is "German (Swiss)".
SELECT Subject FROM NLOutbox
WHERE Sent IS NULL
ORDER BY Subject
ResolutionFixed Problem on 3/4/2001 in version 2.08 build 1