There are a number of possible causes. CFMX uses Unicode by default, but SQL Server assumes non-Unicode input. Edit the CF Admin datasource and check the box under advanced: "Enable Unicode for data sources"
That may or may not fix it. > -----Original Message----- > From: Kelly [mailto:[EMAIL PROTECTED] > Sent: Wednesday, 23 July 2003 4:12 p.m. > To: CF-Talk > Subject: Funky characters on output > > Ok not really sure what is going on. I have a site that was running just > fine. It allows people to keep an online dream journal. I moved to a new > server and transfered the site and database over. Ever since that time > there > are now these weird characters that show up in cold fusion output. > Basically > any strange quotes, greek letters, or anything like that will just show up > as a SQUARE instead of the real symbol. Before I moved everything this was > not occuring. And if you go straight into the SQL database you see the > correct symbols. So something is happening on the output. I am using SQL > 2000 and CF MX. Has anyone run into this before? Any idea how to fix the > problem? > > Just so you can see an example I am posting a link below that will show > you > what the output looks like when this happens > http://www.dreamjournal.org/dj/index.cfm?do=definition&id=800 > > Thanks > Kelly > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
