Hi all, I did this before lots of time but I want to ask again here. May be one of you (specially PaulH) would have a better solution.
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. 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 Unicode database. This is not a complicated process specially when you have a code which reads table field names etc. But still if table amount is more than expected, I would like to see an easy way to do this process. I am using SQL Server / MySQL and I think there must be a way of converting this data into Unicode direct in SQL level. Or another better solution? If you can share your experiences with me, that would be really great! TIA! OÄuz Demirkapı TeraTech Inc. | Senior Developer 405 East Gude Dr Suite 207, Rockville, MD 20850, USA Voice: +1 (301) 424-3903 ext 111 | Fax: +1 (301) 762-8185 Web: http://www.teratech.com | E-mail: oguz.demirkapi <AT> teratech.com Winner in CFDJ awards Best Consulting. Member Team Fusebox. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270158 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
