Re: Order by (Values above 127 ASCII)

for your question; >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 i don't know whether there is a "direct" solution for this problem or not. what we do for this is that to "map" characters with others, store them in an other field and make a sort according this column (unfortunately informix does not perform turkish sorting) for example; in the turkish alphabet there is a letter between "c" and "d" of which spelled as "che". it's ascii equvilent is somewhere above 127. we replace this letter with the next letter and so on.. and sorting is performed according to converted letters. TURKISH ALPHABET ENGLISH ALPHABET a a b b c c \\c (che) d d e e f f g g h . . . for example name "a\\ce" is stored to another column as "adf" by coding a small function, you can use this techique. you can also give a define a function that gives a numerical "weigth" to the letters according to their order and keep this value in other column.... ==================================================================== Omer OZTAN Research Assistant e-mail Middle East Technical University omer@rorqual.cc.metu.edu.tr President's Office oztan@daimler.me.metu.edu.tr Computer Center omer@knidos.cc.metu.edu.tr oztan@ceng.metu.edu.tr ====================================================================