Victor Moore wrote: > What is the best collate for a site database that has to support multiple > languages simultaneously, including double byte: Chinese, Korean, Japanese.
i imagine that depends on the db, but if you're storing what you refer to as "double byte" data in the same table, then of course unicode. again depending on your db, you might be able to "cast" your unicode collation to another (say for sql server): select * from unicodeTest order by unitext COLLATE Chinese_PRC_Stroke_CS_AS_KS_WS ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:251120 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
