I'd imagine the difference is in how the CF servers treat characters. We ran into some issues on one of our projects that displayed different languages when testing it out on CFMX 6.1 Things worked perfect on CF5 but not so perfect on 6.1 This was a couple years ago so I do not recall all the specifics but I think after all the research on it they determined they would either have to change some setting in the Oracle database that would effect all tablespaces or just stay on CF5. They opted to stay on CF5 since the DBAs were unwilling to make such a change on the shared server and wanted to charge a small fortune to setup a stand alone DB for that one app. I think the issue came down to CF5 uses ASCII and MX is UTF8 but again this is going on several years worth of memories and I have slept a few times since then.
On 5/22/07, Colin Jones <[EMAIL PROTECTED]> wrote: > > >Colin Jones wrote: > >> Our pages were previously using UTF-8 for display. You can actually > see the > >> problem here: > > > >cf5 didn't know encoding from a hole in the ground. double checked that > the data > >is ok? we had to dump & re-import many db (sql server) to migrate from > cf5 > >hacked unicode to cf6. > > > > Well it *appears* to be OK. If we use command line SQL to extract a field > with data from the old oracle database, and do the same on the new one, the > data displayed is identical. > > If you do the same thing using the command line with the Oracle drivers on > the server which has CF5, and again use the command line Oracle driver on > CFMX7.0, you also get the same data. > > Difference is either therefore something that CF7 is doing itself > (although I'm not sure what), or the DataDirect JDBC driver. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 and Flex 2 Build sales & marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278890 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
