This does it via Java.Nio.Charset. You feed it into the function and it returns it as Unicode. Then you can store it.
http://www.phillipholmes.com/?p=46 Warmest Regards, Phillip B. Holmes http://phillipholmes.com -----Original Message----- From: Oßuz Demirkapñ [mailto:[EMAIL PROTECTED] Sent: Monday, February 19, 2007 7:20 PM To: CF-Talk Subject: Data conversion into Unicode 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 The most significant release in over 10 years. Upgrade & see new features. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270159 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
