Insert chars with line feed

Markus123 · #1 (**permalink**) 11-18-04, 11:14

Hi,

my table looks like:

MyTable:
id: integer
text: varchar(230)

I want to insert new data, which contains a carriage return (#13) or line feed (#10). So I need something like this:

insert into mytable (id, text) values (1, 'blabla#13#10moreblabla');

I'm using MySQL 4.1 and I've tried many things, but nothing helped

Thanks for your help,
Markus

Pat Phelan · #2 (**permalink**) 11-18-04, 12:14

I'm not where I can test this, but could you use:

Code:

insert into mytable (id, text) values (1, 'blabla
moreblabla');

-PatP

Markus123 · #3 (**permalink**) 11-19-04, 02:21

Hi Pat,

thanks for your help. But sorry, this doesn't seem to work. I found some hints, using

Code:

insert into mytable (id, text) values (1, concat(concat('blabla', char(#13)), 'moreblabla'))

but this also doesn't really works

Greetings,
Markus

Internet Services

Web Development

Digital Marketing

Consumer Tech