Re: Line Breaks Problem (\r\n) in Query
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 WHERE column_name LIKE 'value%'; You won't have to change any of your indexes or table structures, your indexes will still be used for a fast search. On Apr 5, 2005, at 9:18 AM, [EMAIL PROTECTED] wrote: 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 simple table like describe table_name; +-+--+--+-+- ++ | Field | Type | Null | Key | Default | Extra | +-+--+--+-+- ++ | table_name_id | int(10) unsigned | | PRI | NULL| auto_increment | | column_name | varchar(30) | | | | | +-+--+--+-+- ++ My table 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! -- Andrew Bidochko -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- Brent Baisley Systems Architect Landover Associates, Inc. Search Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: line breaks
On Fri, Jan 31, 2003 at 06:22:50PM +0200, Tarik Kutluca wrote: Hi, From a web form I am collecting information to a table. On the form there is a textarea element storing to a text field on the mysql table. Since the textarea can hold the enter key, it's stored in to the field also, but when i try to call that cell and display it on the web page, i see that line breaks are ignored. But the sentences must be displayed as they are entered. - what is the stored character code of the enter key in the text field, i am figuring out to find that character and replace it with the br element, for the exact display, - do you have a shorter way to do this? When HTML agents display text, they are supposed to fold all whitespace characters (newlines, tabs, spaces) into a single space character unless the text is contained in a pre/pre block. The characters that make up a new line sequence vary depending on the operating system of the client. Unix-like OSs use ASCII character code 10, Windows uses 13 followed by 10 and Macs (but likely not OS X+) use 13. If you are using PHP, just call nl2br() on the text before you display the text. Cheers! -- Zak Greant [EMAIL PROTECTED] | MySQL Advocate | http://zak.fooassociates.com MySQL Tip: Show the configuration options set in the server % mysqld --print-defaults My punctuality is well known. When the revolution takes place, I'll be late and I'll be shot as a traitor. --Traitor by the SugarCubes - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: line breaks
Hi. In which way is this a MySQL related problem? Please choose a more appropriate forum next time. On Fri 2003-01-31 at 18:22:50 +0200, [EMAIL PROTECTED] wrote: Hi, From a web form I am collecting information to a table. On the form there is a textarea element storing to a text field on the mysql table. Since the textarea can hold the enter key, it's stored in to the field also, but when i try to call that cell and display it on the web page, i see that line breaks are ignored. But the sentences must be displayed as they are entered. - what is the stored character code of the enter key in the text field, i am figuring out to find that character and replace it with the br element, for the exact display, Depends on the browser used to enter the text. Usually it's '\n' (i.e. the character with code 10 resp. hex 0x0A) - do you have a shorter way to do this? Not really, except if you are happy with using PRE Bye, Benjamin. -- [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: line breaks
Tarik, - what is the stored character code of the enter key in the text field, i am figuring out to find that character and replace it with the br element, for the exact display, The character is \n (the new line character). If you use PHP and have magic_quotes=on in your php.ini, PHP will automatically escape certain characters like \n. If magic_quotes=off, you can use the addslashes() function to accomplish this. When retrieving the data out of MySQL to display them in a textarea field once again, you have to do nothing. The web browser will take care of converting \n into something the operating thinks is a new line (Unix: \n, Windows: \r\n, MacOS: \r). If you want to display the data outside of form fields, you will have to convert \n into something HTML knows is a new line. HTML uses for example br or p for this. In PHP, you can use the nl2br() function that will convert \n into br. If you don't use PHP, things might be a bit more complicated. Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: Tarik Kutluca [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, January 31, 2003 5:22 PM Subject: line breaks Hi, From a web form I am collecting information to a table. On the form there is a textarea element storing to a text field on the mysql table. Since the textarea can hold the enter key, it's stored in to the field also, but when i try to call that cell and display it on the web page, i see that line breaks are ignored. But the sentences must be displayed as they are entered. - what is the stored character code of the enter key in the text field, i am figuring out to find that character and replace it with the br element, for the exact display, - do you have a shorter way to do this? thank you - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php