Ok, looks like I'm answering my own question. Turns out that <cfxml> inserts a UTF-8 encoding in the xml header. When you declare a variable as "XML" in SQL, it uses the system-default encoding of UTF-16. My solution was to pass in the data as "text", then CAST( AS XML) before using it.
-----Original Message----- From: Leitch, Oblio [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 21, 2008 8:57 AM To: CF-Talk Subject: queryparam for xml datatype? I want to pass an xml doc to my query. What queryparam type should I use? I assumed cf_sql_longvarchar, and toString(myXML), but it complained about "swithing encoding". Any suggestions? This email message may contain privileged and/or confidential information. If you are not the intended recipient(s), you are hereby notified that any dissemination, distribution, or copying of this email message is strictly prohibited. If you have received this message in error, please immediately notify the sender and delete this email message from your computer. CAUTION: The Agency of Human Services cannot ensure the confidentiality or security of email transmissions. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305813 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
