I upgraded from MySQL 4.0.12 to MySQL 4.0.18 last night and found some oddities this morning. Apparently some of the varchar data being input into certain tables had carriage returns: "\n" in the data. This was an accidental thing, but on 4.0.12, the \n was ignored when matching on that record. However, now in 4.0.18 it seems to include that when determining matches. For example: select * from table where record='abc'; used to match both 'abc' and 'abc\n' but now only matches 'abc'. Did I miss something in the change history that said this should now happen or is this an undocumented difference? Thanks, Brian Stanton Systems Administrator, Belo Interactive
