How to enter new line using sql command INSERT

sql newline informix dml
Anyname Donotcare picture Anyname Donotcare · Sep 11, 2011 · Viewed 19.3k times · Source

Q:

I wanna to know the syntax of SQL query of inserting new line in my table.

I mean ,I wanna to enter the following in my table abc:

  aaaaaaaaaa

  bbbbbbbbbb

  cccccccccccc

Maintaining the new line.through INSERT command .

Thanks in advance

Answer

Richard picture Richard · Sep 11, 2011

When I answered this question, you'd got it tagged with SQL Server 2008. You've since edited it to be about Informix. The following works for SQL Server 2008.

INSERT INTO MyTable(MyField) VALUES('AAAAA' + CHAR(13) + CHAR(10) + 'BBBBB')

Informix looks more complicated. You have to set an option according to this documentation I found with a google for "informix sql newline"

EXECUTE PROCEDURE IFX_ALLOW_NEWLINE('T')

Related questions

'^M' character at end of lines

When I run a particular SQL script in Unix environments, I'm am seeing a '^M' character at the end of each line of the SQL script as it is echoed to the command-line. I don't know on which OS …

Read More
insert a multiline string in Oracle with sqlplus

I have a SQL script that will insert a long string into a table. The string contains a new line (and this new line is absolutely necessary), so when it is written in a text file, the query is split …

Read More
How do you insert a line break into a DB2 SQL PL VARCHAR variable?

It seems like this should be tremendously easy, but I've had no luck thus far.

Read More