Hi Kami, >>Not sure what you mean with this. Is "sz" considered to be a single, >>indivisible unit in your example? > yes! > > here are some example (| signs the nex letter): > > |sz|e|r|e|t|e|t| > > |t|u|ty|i|mu|u|ty|i| > > |dzs|u|n|g|e|l| > > |M|�|ty|�|s|
I actually didn't try those concrete examples, but the collation should be able to handle such things. Basically, this is called "decomposition" (if I understand it correctly :) - determine whether successive characters are to be considered as a single token. Did you try your example with OOo/HSQL? What's the outcome? (just enter some such strings into a table, and sort by the respective column) Ciao Frank -- - Frank Sch�nheit, Software Engineer [EMAIL PROTECTED] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Database http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
