uh oh - we are talking cf5 here. hopefully not for too long, 6.1 is on the horizon for our production sites, and after we resolve some bugs with 7 and COM we will be there too.
So here it is, we are trying to do this on cf5 right now. One more thing is that I have discovered is that unless I specify <cfprocessingdirective pageencoding="utf-8"> on the page the characters are displayed in the wierdest fashion. Does this mean that browsers dont take much notice of this? <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> or is there some sort of hierarchy? or does it have something to do with the way they were stored? Thanks for all your help paul - I am a little confused but the smoke is clearing slowly. On 10/5/05, Paul Hastings <[EMAIL PROTECTED] > wrote: > > Duncan wrote: > > On the collation end, we are looking over 18 languages, I think thats > pretty > > much any character under the sun. We have a db table, one column for > each > > language, so I am thinking I take Andy's suggestion and make the > collation > > 18+ columns? i'm not sure that wide is the way to go but i guess db > design styles have changed over the years. > > > on each individual column fit the language, rather than simply making > them > > UTF-8. Would this be a more effective use of SQL memory? > > sql collations have 3 parts: unicode, non-unicode & codepage for the > non-unicode data. so you should certainly store your data as unicode > (ucs2 NOT raw utf-8 like the bad old cf5 days, the JDBC driver will > handle the conversion) using "N" datatypes but you can use whatever > collation you want (this used to depend on what codepages were installed > on the sql server, not true for win2k on). the default db collation > should be the one that covers most of your languages. > > just an fyi, collation is a tricky business, there are sometimes more > than one "commonly" used collation for a language (for instance german > phonebook vs dictionary) so deciding which one to use (or is "more > common") will require some research on your part--don't just pick the > first one in the list ;-) > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:220101 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
