Re: Order by (Values above 127 ASCII)

> Subject: Order by (Values above 127 ASCII) > Date: 18 Apr 1995 21:31:42 GMT > Reply-To: natal@telepac.pt (Joao Natal) > Organization: telepac > > Hi people, > > Do you out there know how does Informix-4GL (or for that matter any other > Informix product) order values above 127 ASCII ? > > Thanks in advance. > > Joao Natal > > +----------------------------------------------------------+ > | Joao Natal | E-mail : natal@telepac.pt | > | Est. Ext. da Circunvalacao, | Voice : 351-02-523516 | > | 7996 3o. Dto. | Fax : 351-02-523516 | > | 4200 Porto | | > | Portugal | | > +----------------------------------------------------------+ Ola' Joao, Your question has a two part answer, one of which I know and the other I can only guess at. As far as I know, the English language versions of Informix (and Oracle too, I believe) make no distinction between ASCII values <128 and >127. Thus, sorting is on the binary bit values. Now for the guess: National language versions of DBMS products may make attempts to sort the byte values >127 that represent accented characters and so forth into the normal sort order for those languages. This would be implemented by enhanced sort / order by modules, at the cost of some performance penalty. I know that I have read about this being done in the past, but I do not know whether current versions of DBMS products still do this. Regards, Alan +---------------------------+-----------------------------------------------+ | R. Alan Popiel | Internet: alan@den.mmc.com | | Lockheed Martin, SLS | Voice: 303-977-9998 | | P.O. Box 179, M/S 3810 | Standard disclaimers apply. Cutesy ones, too. | | Denver, CO 80201-0179 USA | Your mileage may vary. Void where prohibited. | +---------------------------+-----------------------------------------------+