Thanks, Paul. I thought AL32UTF8 was only supported in Oracle 8i. We are going to try creating a new db with UTF8 and see if that works. We've determined that the problem isn't soEditor--it's CFMX/Oracle (either drivers or character set issues). Anyone have experience with Unicode in Oracle and CFMX? Pam
-----Original Message----- From: Paul Hastings [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 12, 2003 1:51 PM To: CF-Talk Subject: Re: CFMX Unicode and Oracle w/soEditor > We are using soEditor to allow users to edit db content. When we > update the Oracle db using a UTF-8 value such as λ, it works > fine. When we load it in soEditor to edit again, the HTML source > displays the actual character rather than the numeric value. That's > still displays correctly in the browsers, but when we save the actual > character to the db, it changes to a question mark. first off what oracle calls "UTF8" isn't what the rest of us know as "UTF-8" (if thats what you meant). you should use AL32UTF8 encoding in oracle. bearing in mind that i'm less than newbie with oracle, is the column holding the "unicode" text defined with a unicode capable data type? farcry uses soEditor & we got it all i18n making changes to the farcry cf code & db definitions, not anything w/soEditor. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
