Thanks for all the help guys. Bart, The \015\012 seems to be working fine for me. Thanks for the help.
Mark -----Original Message----- From: Bart Lateur [mailto:[EMAIL PROTECTED] Sent: Thursday, July 15, 2004 10:37 PM To: [EMAIL PROTECTED] Subject: Re: How to insert CR/LF into Sql Server database? 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.
