argh. I had begun to think it might be something like this. i'll keep playing but I fear you're right, the only way to rectify this is have an older version of CF pull it out and post it to cfmx on another server. What a nightmare.
I wonder though whether it's a CF thing or a copy/paste thing - can encoding elements from word be pasted into a plain textarea on a website? Or is it more likely that the earlier version of CF stored things incorrectly and cfmx finally does it right? cheers, Toby Wednesday, January 29, 2003, 1:35:36 PM, you wrote: JvD> Toby Tremayne wrote: >> ok I've tried this again and have some interesting results. I used >> pgAdmin's migration tool to try to move the data across - I created >> the pg database as unicode, and used the unicode option for the >> migration - and ended up with an error: >> >> An error occured at: 29/01/2003 11:11:54 AM: >> -2147467259: ERROR: Invalid UNICODE character sequence found (0xee7472) JvD> That is the typical error when inserting high ASCII in a PostgreSQL JvD> database. >> Any ideas? I can only assume that either there's some weird character >> gone in through a copy and paste from msword to the website textbox >> used for input, as Paul suggested, or CF4/5 has saved bad unicode in >> there and now I'm stuck with it. how does one go about correcting >> something like this? JvD> There is the hard way. You need to extract the data from the database JvD> using CF 4.5, then cfhttp it to CF MX, use setEncoding() to fix the JvD> charset there and then insert it into the database. JvD> And there is the uncertain way. It should be possible to import the data JvD> correctly in some PostgreSQL database with encoding ISO-xxx. Then you JvD> should be able to use the built-in Convert() function to convert to JvD> unicode, which would eliminate the cfhttp step. Haven't tried that though. JvD> Jochem JvD> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
