>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:278868 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
