This content has been marked as final. Show 7 replies
depending on what you want to do with the text you could always use the <cftextarea> tag with the richtext tag set to "yes". This will give your users a WYSIWYG editor (it's actually the FCKeditor) for the text box and when someone tries to paste Word content it asks them if they want to clean it up before pasting it into the textarea.
thanks v much for your suggestion tho - i'll deff look into that aswell - cheers
> when we output that cell from the db, we often find there are ? [question
> marks] where there once were special characters in the Word doc text.
because your db's encoding doesn't support ms's latin-1 superset. if you want to
preserve these chars, change it to unicode. cf's default encoding (since version
6) is utf-8 so it's ready.
Thanks Paul and Azadi
Paul - when you say "change it to unicode" do you mean the page or a setting in the db? forgive me if i'm being stupid but this is all new territory to me. Thank you ever so much for your help - does sound logical what you say :)
Azadi - thanks very much for this (I'm pressuming that there's a charge for this udf) so i'll try to implement Paul's solution and if I can't do that I'll buy the the udf - thanks very much indeed for your help, really is much apprecaited.
> Paul - when you say "change it to unicode" do you mean the page or a setting
cf already defaults to unicode. change the db & use the JDBC driver that comes w/cf.
i'm not a mysql expert but i think it's just
SET NAMES utf8;
SET CHARACTER SET utf8;
BUT make sure you have everything backed up 1st. or even better read the mysql
manual on unicode.