Skip Menu |
 

This queue is for tickets about the DBD-ODBC CPAN distribution.

Report information
The Basics
Id: 43539
Status: resolved
Priority: 0/
Queue: DBD-ODBC

People
Owner: Nobody in particular
Requestors: William.Flynn [...] ftc.usda.gov
Cc:
AdminCc:

Bug Information
Severity: (no value)
Broken in: (no value)
Fixed in: 1.18_4



Subject: Additional info for #43451
Date: Mon, 23 Feb 2009 08:49:09 -0700
To: <bug-DBD-ODBC [...] rt.cpan.org>
From: "Flynn, William - Fort Collins, CO" <William.Flynn [...] ftc.usda.gov>
Download (untitled) / with headers
text/plain 2.1k
Last week I reported this problem: Inserting more than 8,000 characters into SQL Server varchar(max) field gives "Invalid precision value" error It was assigned #43451. I was able to further characterize this problem and have additional information and sample code that should help with troubleshooting. There are two variables involved: Parameter value length: <= 8,000 bytes or > 8,000 bytes Parameter value binding: Yes or No <= 8,000 chars > 8,000 chars No binding Works Works Binding Works Fails To reproduce the problem create a SQL Server database named MyDB with a single table named MyTable with a single column named BigData of type varchar(max). Execute this Perl code: use DBI; my $eightThousandChars .= '12345678901234567890123456789012345678901234567890123456789012345678901 234567890'x(100); my $eightThousandAndOneChars = $eightThousandChars . "1"; my $dbh = DBI->connect("DBI:ODBC:Driver={SQL Native Client};Server=localhost;Database=MyDB;Trusted_Connection=yes;"); # Insert 8,000 characters into a varchar(max) without parameter value binding. # This works. my $qry = "insert into MyTable values ('$eightThousandChars')"; my $insh = $dbh->prepare($qry); my $rowcount = $insh->execute(); # Insert 8,001 characters into a varchar(max) without parameter value binding. # This works. $qry = "insert into MyTable values ('$eightThousandAndOneChars')"; $insh = $dbh->prepare($qry); $rowcount = $insh->execute(); # Insert 8,000 characters into a varchar(max) with parmeter value binding. # This works. my @data = ($eightThousandChars); $qry = "insert into MyTable values (?)"; $insh = $dbh->prepare($qry); $rowcount = $insh->execute(@data); # Insert 8,001 characters into a varchar(max) with parameter value binding. # This fails with: Invalid precision value (SQL-HY104) @data = ($eightThousandAndOneChars); $qry = "insert into MyTable values (?)"; $insh = $dbh->prepare($qry); $rowcount = $insh->execute(@data); The very last execute will fail. Bill... Bill Flynn (Vistronix Contractor) Senior Programmer (.NET, C#) USDA NRCS ITC 2150 Centre Ave., Building A, Suite 231 Fort Collins, CO 80526-8121 (970) 295-5613 (voice) william.flynn@ftc.usda.gov
Download (untitled) / with headers
text/html 10.4k
Download (untitled) / with headers
text/plain 655b
On Mon Feb 23 10:50:19 2009, William.Flynn@ftc.usda.gov wrote: Show quoted text
> Last week I reported this problem: > > Inserting more than 8,000 characters into SQL Server varchar(max) field > gives "Invalid precision value" error
Apologies for not replying to your bug report sooner. I normally get emails from the rt system when a bug is posted or changed but I have received none recently and did not notice this until I spotted the following thread on perl monks: http://www.perlmonks.org/?node_id=746522 I will try and look in to this in the next few days but I think it may already be fixed. Will get back to you soon. Martin -- Martin J. Evans Wetherby, UK


This service is sponsored and maintained by Best Practical Solutions and runs on Perl.org infrastructure.

Please report any issues with rt.cpan.org to rt-cpan-admin@bestpractical.com.