The short-circuit worked like a dream Paul, problem solved. Thank you very much for the assistance :)
On 4 January 2013 11:18, Paul Hastings <p...@sustainablegis.com> wrote: > > On 1/4/2013 6:08 PM, Edward Chanter wrote: > > > > Thanks Paul, the data isn't coming from a form it's being manually > entered > > you mean from a static cf page? and is that page UTF-8? where's the pound > symbol > coming from? > > if you're not using cfqueryparam, make sure to use unicode hinting > (N'text'). > > > Interestingly your reply to this thread shows on my system with my £ > > replaced with a �. That suggests fonts somewhere along the line... > > that's the way it came thru the mail servers. > > > if you want to short circuit this, use the unicode codepoints for those > symbols > > ie, N'#chr(163)#' for the pound sterling symbol. > N'#chr(8364)#' for the euro, etc. > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353760 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm