Anyname Donotcare Anyname Donotcare - 1 month ago 8
SQL Question

How to enter new line using sql command INSERT

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

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')
Comments