Hi,
I discovered that when a SELECT stmt with a ORDER By clause in informix will always sort the results from capital "A" to "Z" then all lower-case "a" to "z". But ideally, what I wants is the results from A to Z regardless of (upper or lower) case. I know is has to do with sort order or collation. In SQL Server 2000, you can rerun the install process to correct it, but I don't know how to do it in Informix.
I'm managing a informix DB running IUS 9.14 UC1 (from onstat -V) on Irix 6.4 OS. I appreciate if you ppl out there could enlighten me in my question. Thank you very much in advance.
I discovered that when a SELECT stmt with a ORDER By clause in informix will always sort the results from capital "A" to "Z" then all lower-case "a" to "z". But ideally, what I wants is the results from A to Z regardless of (upper or lower) case. I know is has to do with sort order or collation. In SQL Server 2000, you can rerun the install process to correct it, but I don't know how to do it in Informix.
I'm managing a informix DB running IUS 9.14 UC1 (from onstat -V) on Irix 6.4 OS. I appreciate if you ppl out there could enlighten me in my question. Thank you very much in advance.