Thanks. for all your input... it really helps me. from your explanation... you make it clear that there is NO WAY cf7 query in a way like cf5 does ?
Our website... www.ilovesmart.com is quite active... so... at this moment... we do not want to take the risk to convert from cf5 to cf7 Unless we can find somebody (or company) who can guarantee the process of this transition. if somebody (or company) interested to take this JOB... please let me know... our company is really interested. Back to those above..... so...we have another server running cf7. ... whith application that needs to read customer data from those server running cf5 so... we have two options... - make a synchronization... between 2 databases... in two different server... (only fields which contains customer data address, name, etc) - Find a way... that cf7 can read database from those cf5 server... (maybe through third party script ? ... or ... I don't know) There must be a way..... or is it really NO WAY ? - What about the next cf8.... I really headache and confused about this encoding... Any suggestion would be very helpful. Thanks. On 5/23/07, Paul Hastings <[EMAIL PROTECTED]> wrote: > > kondo nugroho wrote: > > Most of the records are in Japanese, which is written into the database > > field (nvarchar) using windows default encoding. > > no, cf5 doesn't know anything about encoding, it simply passed whatever > data you > add through to the db. your data is for sure mangled. > > > Our problem is ... how to use this CF7 to get the query from those > database > > (which was written by CF5) > > Because MX7 by default read the database using utf-8... while those > database > > is written by CF5 using different encoding. > > you can't. if you need to support both cf5 & cf7 then you'll need two > different > databases. you'll first need to export all the cf5 mangled data using > cfhttp > pages on the cf5 server & called from the cf7 server that would re-insert > the > data as *real* unicode or Oðuz's xml trick, both amount to the same thing, > what > went in via cf5 has to come out via cf5. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Macromedia ColdFusion MX7 Upgrade to MX7 & experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278965 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
