Line Breaks Problem (\r\n) in Query

2005-04-05 Thread bidochko
Hello, I recall this problem again. No answer still. If I need to talk to other list(probably internals) just let me know. - I would like to describe the following problem and get an opinion from list members. I have

Re: Line Breaks Problem (\r\n) in Query

2005-04-05 Thread Brent Baisley
I'm not sure what may have changed, but what you are searching on is really a partial value of a field. You wouldn't normally think of \r\n as characters, but they are are, just like a or b. Whenever you are searching on a partial value, you should use LIKE and %. SELECT * FROM table_name

Re[2]: Line Breaks Problem (\r\n) in Query

2005-04-05 Thread Andrew
Hello Brent, Thanks for reply. But I would like to know if we have desired behavior in latest versions of MySQL or it is a bug. -- Best regards, Andrewmailto:[EMAIL PROTECTED] Tuesday, April 5, 2005, 11:46:57 AM, you wrote: BB I'm not sure what may

Re: Re[2]: Line Breaks Problem (\r\n) in Query

2005-04-05 Thread Joerg Bruehe
Andrew, you can tell the answer from Brent's info (not obvious in your mail, as you put your new text above the quote): Am Di, den 05.04.2005 schrieb Andrew um 18:05: Hello Brent, Thanks for reply. But I would like to know if we have desired behavior in latest versions of

Line Breaks Problem

2005-04-04 Thread bidochko
Hello, I would like to describe the following problem and get an opinien from list members. My database values contains line breaks ('\r\n'). For example I have 1 row with 'value\r\n' in 'column_name'. SELECT HEX(column_name)FROM table_name; will return 76616C75650D0A I'm