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:308864 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
