Scott, You were right although I don't quite understand what's going on here.
I copied that text from an Internet Explorer browser, pasted it into my HTML form. The text looks fine when previewed from Java but once its inserted into MySql its all funky. I was skeptical so I hand typed the exact same text. This time it looks correct after inserting in the db. Then I tried another test. I copied the same text from a Netscape browser and used Netscape to perform another insert. The text remains correct after insert to the db. So you're assumptions about a Microsoft product seem to be correct. Hopefully I'll find a workaround. Thanks! Tony -----Original Message----- From: Scott Eade [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 15, 2002 12:15 AM To: Turbine Torque Users List Subject: Re: Problems storing quotes in VARCHAR and LONGVARCHAR Tony, I have only experienced the type of problems you describe when dealing with content pasted from a Microsoft product, the most likely candidate being Word. Is this where the problem content is originating from? Also, what version of the mysql JDBC driver are you using? If it is not a recent version then it may be worth a shot to upgrade. A search of the mail list archives should reveal the property that logs the SQL statements (although I seem to recall that not all operations are logged). HTH, Scott -- Scott Eade Backstage Technologies Pty. Ltd. http://www.backstagetech.com.au > From: "Tony Spencer" <[EMAIL PROTECTED]> > > When I call save on an object Torque doesn't seem to be properly handling > certain characters such as ' and ". I get weird crap after the insert is > performed. For instance: > > ORIGINAL TEXT: > Federal Computer Week named SSB one of the �Top 10 companies to watch� and > concluded, �Of the compliance software we�ve seen, InFocus offers the most > power.� A Government Computer News analyst stated, �The best tools I�ve seen > for Section 508 compliance come from SSB Technologies.� > > TEXT AFTER INSERT (i did a select in mySql to get this) > Federal Computer Week named SSB one of the ?Top 10 companies to watch? and > concluded, ?Of the compliance software we?ve seen, InFocus offers the most > power.? A Government Computer News analyst stated, ?The best tools I?ve seen > for Section 508 compliance > come from SSB Technologies.? > > TEXT AS IT APPEARS WHEN RETRIEVED AGAIN VIA TORQUE > Federal Computer Week named SSB one of the Top 10 companies to watch and > concluded, Of the compliance software weve seen, InFocus offers the most > power. A Government Computer News analyst stated, The best tools Ive seen > for Section 508 compliance come from SSB Technologies. > > Has anyone experienced the same problems? Do you know if there is a debug > property I can turn on to view the SQL generated to create inserts on a > table? Any suggestions? > > I would think that Torque is generating prepared statements which should > handle the quotes properly. > > I'm using MySQL v. 3.23.53 and org.gjt.mm.mysql.Driver. > > Thanks, > Tony -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
