>Turn on the querylog, and see what query mysql is actually getting. Thanks, Gerald! Indeed the query with £ signs is truncated - mysql isn't getting the last two characters (in this case it should be 424). If one more character were taken off, it would overwrite the table.
update advert set adverttitle='jobs pages', mainbody='idiotic stuff £50605 blahblahblah...', forfurtherinfo='contact Paul Warner, MISD editing this text.', finalcopy='<h3>RESEARCH ARTIST</h3><h3>Management Information Services Division</h3> <h4>Salary: £28,930.00-£50,219.00 pa</h4><p>idiotic stuff £50605 blahblahblah...</p> <p>contact Paul Warner, MISD</p> <p>editing this text.</p> Quote Reference: AF00428, Closing Date: 20 September 2006' where advertid=4 Whereas, if I remove the £ signs, the query is whole and updates fine: update advert set adverttitle='jobs pages', mainbody='idiotic stuff 50605 blahblahblah...', forfurtherinfo='contact Paul Warner, MISD editing this text.', finalcopy='<h3>RESEARCH ARTIST</h3><h3>Management Information Services Division</h3> <h4>Salary: £28,930.00-£50,219.00 pa</h4><p>idiotic stuff 50605 blahblahblah...</p> <p>contact Paul Warner, MISD</p> <p>editing this text.</p> Quote Reference: AF00428,Closing Date: 20 September 2006' where advertid=424 Why, when the £ sign is in the middle of query, does the end get chopped off? I reiterate that the update statement in the java application log is always whole and complete, as in the second version. So it isn't truncated until after it is passed to JDBC... Thanks, Paul -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
