kondo nugroho wrote: > We have a website hosted in a server with Windows 2003 (english version), > Coldfusion 5 (english version) and msSQL 2000 (english version) > Most of the records are in Japanese, which is written into the database > field (nvarchar) using windows default encoding. > I am not sure what type of encoding... but I believe it is written using > ISO-8859-1. > If you are using CF5, you do not have data in Unicode format regardless of having "nvarchar"etc.
> Now... we have another server using windows 2003 (english version) with > coldfusion MX7 > Our problem is ... how to use this CF7 to get the query from those database > (which was written by CF5) > This is one of the big headache specially on database level. To be honest there is no direct answer for this question. But what you need to have is all your data in Unicode format. But then how? :) I did some projects before like that and we just used different techniques. One of them was exporting all data into an XML structure on CF5 and parsing back with CFMX. The other way would be creating a self made parser on CFMX and reading CF5 pages. OF course it depends on your data volume and structure. As I know there are also some 3rd party tools which converts old data into Unicode ones but I can not give a name now. > Because MX7 by default read the database using utf-8... while those database > is written by CF5 using different encoding. > > I have tried <cfdirective....<cfcontent.... etc... but NO luck. > Please if anybody have any experience regarding this > > I would suggest to talk also with your DB guys. These type of problems was a good work possibility for the companies that I worked for. :) > Thank you so much for all your suggestion. > Regards. > Kondo, Japan. > > Probably I will show also a demo about this conversion at my class. Please check MXNA and search as Unicode for future blog entries. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 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. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create Web Applications With ColdFusion MX7 & Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278918 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
