>>Littrell Liu Liénard This is a good example. Liénard comes at the end, because apparently the sort uses the ASCII collating sequence in which é comes after all other non accented characters. A solution would be to have two columns for names, like Name key -------- ----- Liénard LIENARD Littrel LITTREL Liu LIU
And index on the key, not on the name. When you search for a name, you must convert it to a key ans search on the key. This way, the sort would give the correct order. I've made a function that converts iso-8859-1 strings to upper case keys, if you are interested. Now if the Chinese and Japanese names are stored with characters in the Roman alphabet, no problem, sort them as Roman names. -- _______________________________________ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308882 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
