Would using CFQUERYPARAM help? Stace
-----Original Message----- From: Alex Hubner [mailto:[EMAIL PROTECTED]] Sent: Friday, June 21, 2002 2:21 PM To: CF-Talk Subject: CFMX or JDBC madness? Hello, first of all I'll like to introduce myself since I'm new here. I'm a ColdFusion developer (for 2-3 years) and I work for a environmental NGO here in Brazil. I love CFML since the first time I've saw it... As many of us, I'm moving forward in this new CFServer generation and I'm also facing some difficulties on it. Since I'm new to the group and I'm not able to check if this issue was been discussed previously so I'm going to post it because I'm trying hopelessly find the answer for that... :o) Here's the history: I think I have found a problem with the default MSSQL JDBC driver that cames with CFMX. The problem is that when you try to insert data that contains special chars such as smart quotes - also know as curly quotes - ("") and long dashes (-), that are commonly found in Microsoft Word and other text processors, the JDBC driver does not convert it to SQL Server coding (UCS-2) right. It produces interrogation chars (?) in the place of the original ones. I'm using ISO-8859-1 coding on my CFML templates (placing <CFCONTENT>) instead of the default UTF-8. But even with UTF-8 I those chars are not correctly converted to the MS SQL encoding (UCS-2). As a result I found interrogation marks been inserted (and retrieved) in the database. Any other special chars and accents are ok. The strange thing is that this problem does not occours using JDBC type 3 drivers such as the MS Access or any ODBC Socket. Also, in past CFServer versions (4x.5x) that uses ODBC, the problem does not occurs. This is quite serious since most of us have content managment systems (such as news, documents, etc) developed in ColdFusion that perform data insertion (on a database or XML file or both) from Word (copy+paste operations). The journalists on my institution (and many others around the world) simple copy text from Word and than paste it on a TEXTAREA form. This operation does not "clean" the curly quotes and long dashes (even if you paste the data in the NotePad and than copy it again). With CFMX using MSSQL JDBC driver (t4) we get the "?" marks instead of quotes and dashes. Does anybody noticed that? There's a workaround? Microsoft provide, free of charge, a JDBC driver for SQL Server. It's possible to use it instead of the one that cames with CFMX (or to perform an upgrade when it's available)? How can I do that? Bellow i've pasted those curly quotes and dashes (copy and paste it on the notepad to see the differences): Curly quotes: "test" Normal quotes: "test" Long dash: test - test Normal dash: teste - test Thanks! Alex ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm 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
