Re: Sorting

Posted in 1999

Art S. Kagel — Wed, 23 Jun 1999 11:28:27 -0400 — source: Informix-list mailing list archive (1991-1998)

lohmer@lverma.nrw.de wrote: > > Hi, > > I connect to a Informix Dynamic Server 7.23 via ODBC-Driver 'Informix- > CLI 2.5 (32bit)' from a Win-NT4(SP4) Workstation in a VisualBasic- > Programm with Microsoft ADO-Objects. > > My SQL-Statement is: "SELECT * from tabX ORDER BY colName" > > My Problem: The sorting is ASCII-Code, but I wish sorting like Text, > because there are small and great Letters. > So I have 'a' after 'Z', thats my nightmare. > > What can I do? Only three choices: 1) Add an additional column with the same data all upper or lower case for sorting purposes. (Or create another table with the same key and the text column in upper case and sort by that joined back to the original table.) 2) Upgrade to XPO (8.xx) or UDO (9.xx) which implement functional indexes and index on UPPER(column) the ORDER BY UPPER(column). 3) Upgrade to UDO and create a new index type which is case insensitive in a datablade. Art S. Kagel