Paul, That makes sense...the only change was the move from CF 5 to MX and I've been scratching my head about what the heck happened.
In terms of the hint early, hint often stuff, do you recommend the cfprocessingdirective with encoding set to utf-8, on every template? As far as converting the data, if I understand what you're saying, I should run a cfhttp to the cf 5 box, from an MX box, and re-insert the data in the dbase? thanks, Chris On Fri, 04 Mar 2005 10:56:33 +0700, Paul Hastings <[EMAIL PROTECTED]> wrote: > 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:197434 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