Skip to Content.
Sympa Menu

freetds - Re: [freetds] trouble with UTF-8 input data with mssql_bind

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Frediano Ziglio <freddy77 AT gmail.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] trouble with UTF-8 input data with mssql_bind
  • Date: Tue, 08 Dec 2009 08:53:56 +0100

Il giorno lun, 07/12/2009 alle 21.34 -0500, James K. Lowden ha scritto:
> Tomasz Kurkiewicz wrote:
> >
> > I'm using FreeTDS 0.82 to execute a stored procedure on a MS SQL Server
> > 2005. Unfortunately, I keep getting error messages while executing a
> > stored procedure using mssql_bind.
> > Web server is Fedora 8, PHP 5.3.0, freetds 0.82, database server is
> > called MSSQL.
> ...
> > Client encoding is UTF-8, parameters are all nvarchars, it fails on a
> > first nvarchar parameter (look at freetds.log).
> >
> > freetds.log says:
> > "Error converting characters into server's character set. Some
> > character(s) could not be converted"
> > "The incoming tabular data stream (TDS) remote procedure call (RPC)
> > protocol stream is incorrect. Parameter 2 ("@user_agent"): Data type
> > 0xA7 has an invalid data length or metadata length."
>
> I would be interested in a TDSDUMP log that includes the parameter binding
> functions and the error returned by the server.
>
> It's likely you've hit a long-standing problem. There's not much encoding
> conversion built into the parameter binding functions in db-lib. The
> expectation is that the bound buffer holds data encoded in the same form
> as the column to which it applies. That could be changed, but someone has
> to want to....
>

Fixed in 0.82 CVS version, this is a problem of no patched version.

Sun Aug 17 10:42:41 CET 2008 Frediano Ziglio <freddy77_A_gmail_D_com>
* src/tds/query.c: do not loose sync on conversion errors

freddy77






Archive powered by MHonArc 2.6.24.

Top of Page