Did you try using ntext and are you using <cfqueryparam>? Those may help.
-----Original Message----- From: Trishan Singh [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 12, 2002 11:33 AM To: CF-Talk Subject: Re: Funny Looking Symbols (CFMX) I am beginning to run into the same thing... Im running MX enterprise with SQL 2000 and half the time my data type 'text' inputs start adding funky symbols for quotes, ticks, and hyphens but not in a eaisly determined pattern.. '.. affordableâ' Any ideas what im doing...err even not doing ----- Original Message ----- From: "Dwayne Cole" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, September 12, 2002 10:12 AM Subject: Funny Looking Symbols (CFMX) > PROBLEM: > After I switched to CFMX, apostrophy and qoutes contained in database records show up as funny looking symbols. > > CAUSE(I think): > I remember reading somewhere that CFMX needs to know something about a the UTF-8 character set. Is this the source of my problem? > > SOLUTION: > ?????????? this is what I need to know. > > Prof. Dwayne Cole > MS in MIS, MBA > Certified Advanced ColdFusion Developer > 850-591-0212 > > "It can truely be said that nothing happens until there is vision. But it is equally true that a vision with no underlying sense of purpose, no calling, is just a good idea - all "sound and fury, signifiying nothing." The Fifth Discipline - Peter Senge > > ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
