This content has been marked as final. Show 2 replies
> The problem arises when I try to display the content on that field on some
> display templates. The formatting is lost and there are several characters that
> get replaced by ~ as well as little square boxes that are a special character
> that I can't identify.
> Is there anything anyone can suggest on how to approach this problem? is it a
> coldfusion administrator issue, a server setup issue, does word have to be
> installed on the server that the applications run? is it a setting in SQl
> server. I was hoping someone has had a similar problem and can point me in the
> right direction.
It is a character encoding issue. This is a big topic, but there is
plenty written up about it. You probably want to configure your
application use use window-1252 or unicode encoding format. You will
want to make sure the entire system running the application is talking
the same encoding, database web server and ColdFusion.
It sounds like the Word content includes characters like smart quotes which are not HTML friendly. You might try a UDF to replace these characters with an HTML substitute for display.
I have not used either of these samples but they may help you.