RE: $dbh->unquote()

[Paul DuBois]

At 12:24 -0500 3/27/03, Brian Spindler wrote:
Interesting, in my MySQL database the field is a longtext should I change it
to a one of the binary types?
That won't make any difference.

I don't know how your problem occurred in fact, but here's one way that
it *can* occur.  Maybe this will shed some light on your problem.
$x = $dbh->quote ("\n");

$dbh->do ("INSERT INTO t SET col = $x");

That will insert a newline into the database.

$x = $dbh->quote ('\n');

$dbh->do ("INSERT INTO t SET col = $x");

That will insert a literal backslash-n into the database.

See the difference?



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.