Line Breaks Problem (\r\n) in Query

2005-04-05 Thread bidochko
| +-+--+--+-+-++ | table_name_id | int(10) unsigned | | PRI | NULL| auto_increment | | column_name | varchar(30) | | | | | +-+--+--+-+-++ My table values contains line breaks ('\r

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

2005-04-05 Thread Brent Baisley
| | 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

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

2005-04-05 Thread Andrew
| | 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

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

How do you create ascii line breaks

2003-06-06 Thread Daniel Crompton
How do you create ascii line breaks in a text paragraph in mysql?. When displaying text taken from a mysql row it displays it all as a flowing paragraph ie sdf sdfgfj fgjhgfh fgj fgj hfj hj hg gh hgk ghk gj gh kg k hg hg jh j fgj fg When i need to look like sdf sdfgfj fgjhgfh fgj fgj hfj hj

Re: How do you create ascii line breaks

2003-06-06 Thread gerald_clark
Daniel Crompton wrote: How do you create ascii line breaks in a text paragraph in mysql?. When displaying text taken from a mysql row it displays it all as a flowing paragraph ie sdf sdfgfj fgjhgfh fgj fgj hfj hj hg gh hgk ghk gj gh kg k hg hg jh j fgj fg When i need to look like sdf

FW: line breaks

2003-02-01 Thread Sherzod Ruzmetov
: : - 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, That's what's normally done. Line breaks are usually represented by \n escape

Re: line breaks

2003-02-01 Thread Zak Greant
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

Re: line breaks

2003-02-01 Thread Benjamin Pflugmann
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

Re: line breaks

2003-02-01 Thread Stefan Hinz, iConnect \(Berlin\)
: 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

line breaks

2003-01-31 Thread Tarik Kutluca
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