OÄuz Demirkapı wrote: > We have an application which is programmed by using CF5. We have also > lots of data in Turkish and German. (ÄÄ Ä±Ä° ÅŠöà çà à äÃ) But > all these > data has been entered via CF5 and not Unicode in database.
using utf-8 "encoded" cf pages? the german data should be ok "as is" if you stored in non-unicode column & didn't use utf-8 "encoded" cf pages, after all latin-1 is latin-1. but the turkish data (using windows 1254?) is probably another matter. can they be separated out? that might help cut down on what you have to re-encode. > What I do generally is reading from database and exporting into XML via > CF5 and reading this exported XML file with CFMX and writing into an basically that's what we usually did (though it's mx reading a cf5 page that dumps the data out which mx reads & inserts into the db). i'd be curious to see if phillip's way worked w/this kind of mangled data (especially if stored in "N" columns) though i guess you'll have to pull out the data in two separate processes as these are two different codepages. don't think it will work if you inserted the data using utf-8 "encoded" cf pages though, that data is kind of frankenstein-like that only cf5 & an odbc db driver could love ;-) > is more than expected, I would like to see an easy way to do this process. nope, there's always a price to pay for being ahead of your time or forcing a square peg into a round hole ;-) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270162 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
