Chris Poterala wrote: > The site handles multiple languages, both latin and non-latin > character sets (Greek, Russian, Arabic, English, French, Italian, > German...)
and how did you do that w/cf5? stuff raw utf-8 into the db, right? and there's your trouble. > The fields in the dbase that store the data are the proper types > (nvarchar, ntext). I researched and read that MX 6.1 defaults to but i bet they're holding raw utf-8 instead of unicode (ucs-2). > There is no default encoding set on any of the application templates, > since the docs indicate MX defaults to UTF-8. no matter what, you should always "hint early, hint often" when it comes to char encoding. > Are we missing something that's changed with MX with regard to unicode > support? yes, mx actually supports unicode. previous version didn't. > Do we need to use UTF-16 encoding? no. > Any clues, ideas, pointers? one way is to pull your existing data thru a cf5 box's template (that simply dumps out the data) via cfhttp on an mx box which in turn re-inserts the data into your db via mx's jdbc driver converting it to unicode. cf5 made you do bad things like lying to your database for i18n to work. there's a price to be paid for that. if it's any consolation, i had to pay it once too. ps: you should only be using the jdbc drivers. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:197418 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
