Hmmm. Chr(14) is a Shift Out (0x0E in hex). Used to see it occasionally, but not for years now.
Dan Covill On 4/18/2011 3:01 PM, Jarvis, Matthew wrote: > Is it set to 14, or just appearing as 14... > > IOW - is it some ASCII thing i.e. what is CHR(14) ? >> -----Original Message----- >> On Behalf Of Ken Kixmoeller (ProFox) >> Sent: Monday, April 18, 2011 2:32 PM >> Subject: [NF] [MySQL] Weird, weird WEIRD behavior >> >> -- I ran a simple query: >> >> Update the_table set field_A = field_B, field_C = field_D where >> field_a = 0 >> >> -- The intended result was fine, but there was an unintended >> additional result: field_F was set to 14 in all of the affected >> records. _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
