new line in H2 console

[Nitin]

Hi Group,

In browser H2 console, Following updates filed as is ..inserts \n as
text character not new line character in the field.

update mytable set myfield='first line\nsecond line' where id=1;

I tried \\n and "\n" but no success.

I am using H2 1.2.147 console on windows xp.

Thanks.
Nitin

[Thomas Mueller]

Hi,

This is not ANSI standard SQL. \n is C style escaping, and not
supported by ANSI SQL. It is supported by MySQL when ANSI SQL mode is
disabled.

The preferred solution is to use a prepared statement:
update mytable set myfield=? where id=?;

Another solution is to use:

update mytable set myfield='first line

second line' where id=1;

Regards,
Thomas

[Nitin]

It worked with another solution with multi line :)
Thanks alot.

On May 4, 12:36 am, Thomas Mueller <thomas.tom.muel...@gmail.com>
wrote: