>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: > >-- >mxAjax / CFAjax docs and other useful articles: >http://www.bifrost.com.au/blog/
Hmm - we currently have the database set to the same settings as it was originally on the old system ENGLISH_UNITED KINGDOM.WE8ISO8859P1 Obviously that doesn't match UTF-8. I'm really unclear about how character encoding works however. Is this correct: Old System BROWSER PAGE (UTF-8) <=> COLDFUSION 5.0 (??) <=> ORACLE (ISO-8859-1) New System BROWSER PAGE (UTF-8) <=> COLDFUSION 5.0 (UTF-8) <=> ORACLE (ISO-8859-1) Why would the old system display the characters correctly, but the new system will not... given that the browser pages were using UTF-8, but the database was ISO-8859-1. If we have to change the database table type, how will we get the data from the current ISO-8859-1 format into the UTF-8 tables - I assume this isn't a simple export import? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278935 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
