What is the database character set? What's the DB national character set? Are you storing in varchar2s, CLOBs or nvarchar2s (etc)? Since CF 7 will be working in UTF-8 I suspect your DB isn't and the Oracle cilents are set to match the DB (instead of UTF-8).
This may assist: http://download-east.oracle.com/docs/cd/B14117_01/server.101/b10749/ch2charset.htm 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. -- mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278927 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
