Hi Jay,
Try this:
http://www.xaprb.com/blog/2006/04/14/bad-character-data-in-mysql/
Baron
Jay Blanchard wrote:
I did some googleing and some other searching, now I am looking for a
cure all. I have a column into which it appears that a carriage return
has been inserted and it is mucking
Try:
replace(replace(dealerLong, '\n', ''), '\r', '')
Jay Blanchard wrote:
I did some googleing and some other searching, now I am looking for a
cure all. I have a column into which it appears that a carriage return
has been inserted and it is mucking about with some queries;
mysql select
[snip]
Try:
replace(replace(dealerLong, '\n', ''), '\r', '')
[/snip]
Didn't work, perhaps because they are hidden. I ended up taking the long
road;
update table set foo = replace(HEX(foo), '0D', '');
update table set foo = UNHEX(foo);
HEX allowed me to see the carriage return (0D) and then use