|
+-+--+--+-+-++
| table_name_id | int(10) unsigned | | PRI | NULL|
auto_increment |
| column_name | varchar(30) | | | |
|
+-+--+--+-+-++
My table values contains line breaks ('\r
|
| 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 | 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
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
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 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
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
:
: - 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
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
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
: 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
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
12 matches
Mail list logo