Yes, I'd try long raw, see if that helps. Also, as Jeff mentioned, try using binmode.
Ilya -----Original Message----- From: Brian Spindler [mailto:[EMAIL PROTECTED] Sent: Thursday, March 27, 2003 12:24 PM To: 'Sterin, Ilya (I.)'; 'Paul DuBois'; [EMAIL PROTECTED] Subject: RE: $dbh->unquote() Interesting, in my MySQL database the field is a longtext should I change it to a one of the binary types? Brian -----Original Message----- From: Sterin, Ilya (I.) [mailto:[EMAIL PROTECTED] Sent: Thursday, March 27, 2003 11:38 AM To: 'Brian Spindler'; 'Paul DuBois'; [EMAIL PROTECTED] Subject: RE: $dbh->unquote() This depends on what field in the db you are writting to. If it's a raw type or binary field, then you wouldn't have that problem. There might be some conversion going on between the db field, as \n is not a standard carriage return, it's the way Perl interpreter interprets carriage returns on what ever platform it was build on. It might very possibly be converted between an ascii field and DBI. Ilya -----Original Message----- From: Brian Spindler [mailto:[EMAIL PROTECTED] Sent: Thursday, March 27, 2003 11:33 AM To: 'Paul DuBois'; [EMAIL PROTECTED] Subject: RE: $dbh->unquote() If printed in a windows environment "\n" is a carriage return. Brian -----Original Message----- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: Thursday, March 27, 2003 11:32 AM To: Brian Spindler; [EMAIL PROTECTED] Subject: Re: $dbh->unquote() At 11:19 -0500 3/27/03, Brian Spindler wrote: >Hi guys, gals! > > I have a pretty big string that I am inserting into MySQL via the >$dbh->quote($str) function, this works great however now when I pull the >data back out of the database and go to write it to a file the \n characters >that were inserted by quote are not being written back out as carriage >returns as desired. How can do a reverse of quote() or just get those >"\n"'s to print out as they should! =) ahh.. I'm frustrated, I tried >everything even split('\n',$str) and then reinserting the "\n". Doesn't >work, please help! > >Thanks in advance! >Brian What do you mean by "as they should"? After all, "\n" isn't a carriage return.
