RE: AW: CLOB Problem with DBD::ODBC/DBD::ADO for SQL Server
- From: rjk-dbi@xxxxxxxxxxx (Ronald Kimball)
- Date: Mon, 29 Jan 2007 11:21:08 -0500
Martin Evans [mailto:martin.evans@xxxxxxxxxxxx] wrote:
The first issue is the back slashes in the here document.
my $text = <<_EOF;
hello\\\\
_EOF
print length($text), "\n";
prints 8 not 10 because \\ in a here document ends up as \.
So half of
your '\\\\' go straight away to '\\'.
You can use a single-quoted here-doc if you want literal backslashes:
my $text = <<'_EOF';
hello\\\\
_EOF
print length($text), "\n";
prints 10.
A single-quoted here-doc is the only way in Perl to turn off absolutely all
interpolation.
Ronald
.
- References:
- AW: CLOB Problem with DBD::ODBC/DBD::ADO for SQL Server
- From: Alfred Mickautsch
- Re: AW: CLOB Problem with DBD::ODBC/DBD::ADO for SQL Server
- From: Martin Evans
- AW: CLOB Problem with DBD::ODBC/DBD::ADO for SQL Server
- Prev by Date: Re: AW: CLOB Problem with DBD::ODBC/DBD::ADO for SQL Server
- Next by Date: Re: AW: CLOB Problem with DBD::ODBC/DBD::ADO for SQL Server
- Previous by thread: Re: AW: CLOB Problem with DBD::ODBC/DBD::ADO for SQL Server
- Next by thread: Re: AW: CLOB Problem with DBD::ODBC/DBD::ADO for SQL Server
- Index(es):