we are evaluating some ideas to change our "default"-sort order of string columns on the database (oracle 12g), because of some special character(sets). Until now, we supported just usual ansi/german letters, but since database and powerbuilder supports unicode, we would like to accept also other letters with special characters (e.g.: ã,è, ë, ...). One idea is to create a mapping-function (which converts special characters in some ansi-equivalent-characters, ä=>ae, ë=>e) and then use that utility-function in our colums... An other idea is to change the "nls_sort" of our Oracle Database, but then we would have different sort order on database compared to the client (datawindow)... Do you know a way how to change/manipulate the sort order of a datawindow? Or maybe you could exchange some ideas with me which you already used for similar issues...
As far as I see, datawindow sort order is based on the order of the character set (unicode or whatever) which is currently used.
Thank you in advance.