I think Lienard (how do you bring up the symbol on a QWENTY keyboard) is after Liu because that "e" comes after the 26 English alphabet letters. Same reason why Aquist (with that A) is at the end of the list.
On Thu, Jul 10, 2008 at 12:16 PM, Vince Collins <[EMAIL PROTECTED]> wrote: > Good question, actually, upon further clarification, the Japanese names > appear to be using the English alphabet, or at least the Westernized > alphabet. However, I'll give an example. > > The following shows an alphabetical list of last names: > > .... > Littrell > Liu > Liénard > .... > .... > Åquist > > Shouldn't Liénard be listed before Liu? Also, why is Åquist at the end > of the list? > > > > Qing Xia wrote: > > Hmm... this is an interesting problem. > > > > But I am a bit confused: what is your criteria for sorting international > > names? For example, for the Janpanese names, are the actual names stored > > (with Japanese characters), or just the alphabetized version of the them? > If > > the actual Japanese characters are used, then how do they rate in order > > compared to the 26 English alphabets? > > > > For example, my name, "Qing Xia" is the alphabetized version of my "real" > > Chinese name. Which, is easy enough to sort as that. But I can't > imagine > > what criteria would be involved in order to sort the real Chinese > characters > > themselves. > > > > On Thu, Jul 10, 2008 at 11:24 AM, Vince Collins <[EMAIL PROTECTED]> > wrote: > > > > > >> A colleague sent me an email with an interesting problem and therefore I > >> have a challenge for all you who have experience with Internationalized > >> web application development. > >> > >> There is an employee table which contains the first and last name of > >> international employees. This means that it is common to see Japanese, > >> Dutch, French, Russian, Indian and American names and growing...Lots of > >> special characters that when sorted put any name with special characters > >> at the bottom of the list. > >> > >> I know that you could probably sort a field by first assigning a > >> collation such as the following: > >> > >> select lastName, firstName > >> from tableName > >> order by lastName COLLATE Dutch_AI_CI, firstName COLLATE Dutch_AI_CI > >> > >> The of course would be fine if all the employees where Dutch but they > >> aren't. > >> > >> The goal is to provide a simple directory of names. The table is SQL > >> Server 2000 and the language is CF8 running on Windows Server 2003 > >> > >> Any help would be greatly appreciated! > >> > >> > >> > >> > >> > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:308887 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
