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 running the following query (I want to get records and DO NOT
use '\r\n' im my WHERE clause)
SELECT * FROM table_name WHERE column_name='value';
On MySQL Ver 11.18 Distrib 3.23.55 that query returns 1 row,
on MySQL Ver 14.7 Distrib 4.1.9 empty set is return.
I did not found anything in change log files about that difference.
So, I wonder if behavior of newer MySQL version is feature or bug or
bug fix. What is correct?
Thanks!
--
Best regards,
Andrew Bidochko
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
