Bug #43451 for DBD-ODBC: Inserting more than 8,000 characters into SQL Server varchar(max) field give "Invalid precision value" error

Thu Feb 19 18:42:22 2009 William.Flynn [...] ftc.usda.gov - Ticket created

Subject:	Inserting more than 8,000 characters into SQL Server varchar(max) field give "Invalid precision value" error
Date:	Thu, 19 Feb 2009 16:20:12 -0700
To:	<bug-DBD-ODBC [...] rt.cpan.org>
From:	"Flynn, William - Fort Collins, CO" <William.Flynn [...] ftc.usda.gov>

Broken in 1.18 When trying to insert more than 8,000 characters into a varchar(max) field in a SQL Server database the following error occurs: DBD::ODBC::st execute failed: [Microsoft][ODBC Microsoft Access Driver]Invalid precision value (SQL-HY104) Inserting 8,000 characters or less works fine.

Thu Feb 26 09:27:17 2009 bohica [...] ntlworld.com - Correspondence added

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

Thu Feb 26 09:27:18 2009 The RT System itself - Status changed from 'new' to 'open'

Sun Mar 08 13:35:28 2009 bohica [...] ntlworld.com - Correspondence added

On Thu Feb 19 18:42:22 2009, William.Flynn@ftc.usda.gov wrote: Show quoted text

> Broken in 1.18 > > When trying to insert more than 8,000 characters into a varchar(max) > field in a SQL Server database the following error occurs: > > DBD::ODBC::st execute failed: [Microsoft][ODBC Microsoft Access > Driver]Invalid precision value (SQL-HY104) > > Inserting 8,000 characters or less works fine. > >

Are you using Microsoft native Client? Did make test for DBD::ODBC run to completion without errors? What version of DBD::ODBC are you using? If you are using native client then older versions have a bug which leads to the error you are reporting. Have you updated it to the latest version? When you run make test, it will spot older native clients that are broken. BTW, there is no need to start a new rt for followups. Martin -- Martin J. Evans Wetherby, UK

Sat Mar 14 10:58:19 2009 bohica [...] ntlworld.com - Correspondence added

On Sun Mar 08 13:35:28 2009, MJEVANS wrote: Show quoted text

> On Thu Feb 19 18:42:22 2009, William.Flynn@ftc.usda.gov wrote:

> > Broken in 1.18 > > > > When trying to insert more than 8,000 characters into a varchar(max) > > field in a SQL Server database the following error occurs: > > > > DBD::ODBC::st execute failed: [Microsoft][ODBC Microsoft Access > > Driver]Invalid precision value (SQL-HY104) > > > > Inserting 8,000 characters or less works fine. > > > >

I believe this is working in at least 1.18_4 so I'm marking this fixed unless you tell me otherwise. Martin -- Martin J. Evans Wetherby, UK

Sat Mar 14 11:00:05 2009 bohica [...] ntlworld.com - Status changed from 'open' to 'resolved'

Sat Mar 14 11:00:05 2009 bohica [...] ntlworld.com - Fixed in 1.18_4 added