On Thu, 15 Jul 2004 17:53:44 -0400, Bowen, Mark wrote:
>I am trying to insert multi-lne data into a text type column in SQL Server. MS says
>this can be accomplished with the CHAR(13) & CHAR(10) functions, however I cannot get
>these to work in DBI. If I write my text with these functions in them, they either
>get inserted into the database as text, or Perl complains that it cannot find these
>functions in the script. If I insert "\n" into sql server, it comes out as an open
>rectangle (
).
Try "\015\012", or "\x0D\x0A", or even chr(13) . chr(10) (perl code)
--
Bart.
