Yeah, I had the same problem. You will also find that it's not just Unicode that is being pasted from Word, but also special Word "unicode", whose numbers when translated do not match those in the Unicode specification.
You could always save the data in the database by using the CLOB datatype in CFSTOREDPROC or by using the N prefix in your INSERT/UPDATE queries if you really didn't care if it is Unicode or not... Darryl -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of TRACEY, Darren Posted At: Monday, 30 August 2004 3:33 PM Posted To: CFAussie Conversation: [cfaussie] RE: cleaning word crap... Subject: [cfaussie] RE: cleaning word crap... Unicode is the cause of your problems. Word, and most MS products (even wordpad), will stick all sorts of Unicode into what gets cut/pasted out of it. Even simple things like quotes, both single and double, will be converted into unicode equivalents. You should be able to do a search on unicode filtering and get what you need. Regards Darren Tracey Systems Analyst HR Systems and FastTrack, Web and Integration Services p: + 61 7 3232 4091 (x64091) f: + 61 7 3232 4744 e: [EMAIL PROTECTED] l: Lvl 9, 388 Queen St Brisbane QLD 4000 m: Suncorp IPC IT040, GPO Box 1453, Brisbane QLD 4000 > -----Original Message----- > From: rob [SMTP:[EMAIL PROTECTED] > Sent: Monday, 30 August 2004 15:30 > To: CFAussie Mailing List > Subject: [cfaussie] cleaning word crap... > > i am using htmlarea quite a lot and its great i have teachers adding > content from all over the place. However i am getting '?' and other > weird characters all the time and i have no idea how to get rid of > them. > > Has anyone got a replace function that will get rid of ALL these > characters or can point me in the right direction of a solution?? > > Thank you for your time.. > > > Robert Shaw > > > Online Learning > [EMAIL PROTECTED] > MLC School > Rowley Street > Burwood 2134 > Phone: 97471266 > Mobile: 0422222515 > Fax: 97453254 > > > Robert Shaw > Online Learning > [EMAIL PROTECTED] > MLC School > Rowley Street > Burwood 2134 > Phone: 97471266 > Mobile: 0422222515 > Fax: 97453254 > > > --- > You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To > unsubscribe send a blank email to > [EMAIL PROTECTED] > Aussie Macromedia Developers: http://lists.daemon.com.au/ ------------------------------------------------------------------------ ----------- This e-mail is sent by Suncorp-Metway Limited ABN 66 010 831 722 or one of its related entities ("Suncorp"). Suncorp may be contacted at Level 18, 36 Wickham Terrace, Brisbane or on 1800 689 762 or at suncorp.com.au. The content of this e-mail is the view of the sender or stated author and does not necessarily reflect the view of Suncorp. The content, including attachments, is a confidential communication between Suncorp and the intended recipient. If you are not the intended recipient, any use, interference with, disclosure or copying of this e-mail, including attachments, is unauthorised and expressly prohibited. If you have received this e-mail in error please contact the sender immediately and delete the e-mail and any attachments from your system. If this e-mail constitutes a commercial message of a type that you no longer wish to receive please reply to this e-mail by typing Unsubscribe in the subject line. --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
