Skip to Content.
Sympa Menu

freetds - Re: [freetds] Problem with nvarchar output

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] Problem with nvarchar output
  • Date: Thu, 31 Jul 2014 14:41:20 +0100

The upper layer decided to cancel the query. The reason could be previously
in the log.
Looks like you are using an encoding which cannot support your charset
(there are some question marks in the output string possibly result of a
wrong conversion).

Frediano


2014-07-31 9:44 GMT+01:00 Ola Karlsson <olka AT bagheera.se>:

> Hi,
> Sorry for the delay. Went on hollidays for a few weeks :)
>
> As far as I can see my error message is stated in the log exactly as it
> should be and it also states two returned results.
> The integer value is returned correctly but not the nvarchar.
>
> I have attached a portion of the log containing the procedure call and my
> error message.
> I don't notice any error messages or so but then again theres a lot of
> information in the logs.
>
> No errors in the php logs either.
>
> Any ideas?
>
>
> BR
> Ola
>
> -----Ursprungligt meddelande-----
> Från: FreeTDS [mailto:freetds-bounces AT lists.ibiblio.org] För Frediano
> Ziglio
> Skickat: den 12 juli 2014 09:06
> Till: FreeTDS Development Group
> Ämne: Re: [freetds] Problem with nvarchar output
>
> Hi,
> did you check TDSDUMP ?
>
> Frediano
>
>
> 2014-07-06 14:32 GMT+01:00 Ola Karlsson <olka AT bagheera.se>:
>
> > Hi
> > I'm using Freetds with PHP5 to access a SQL server but I'm having
> > trouble with the output parameters.
> > I have two parameters, one SQLINT4 and one SQLVARCHAR. The int is
> > working but I don't get any returns from the varchar.
> >
> > Is there anything special that needs to be done when outputting nvarchar?
> >
> > PHP binds,
> > mssql_bind($stmt, '@ErrorMsg',$ErrorMsg,SQLVARCHAR,true,false,4000);
> > mssql_bind($stmt, '@OrderNr',$OrderNr,SQLINT4,true,true,8);
> >
> > SQL parameters,
> > @ErrorMsg nvarchar(4000) output
> > @OrderNr Jeeves_OrderNo output
> >
> >
> > Sql server,
> > SQL Server 2008 R2
> >
> > Freetds server,
> > Ubuntu 12.04 3.5.0-51-generic
> >
> > Tsql -C
> > Version: freetds v0.91
> > freetds.conf directory: /etc/freetds
> > MS db-lib source compatibility: no
> > Sybase binary compatibility: yes
> > Thread safety: yes
> > iconv library: yes
> > TDS version: 4.2
> > iODBC: no
> > unixodbc: yes
> > SSPI "trusted" logins: no
> > Kerberos: no
> >
> > Freetds conf,
> > [global]
> > text size = 64512
> > [Sqlserver]
> > host = xxx.xxx.xxx.xxx
> > port = xxxx
> > tds version = 8.0
> >
> > PHP5
> > PHP 5.3.10-1ubuntu3.12
> >
> >
> > BR
> > Ola
> > _______________________________________________
> > FreeTDS mailing list
> > FreeTDS AT lists.ibiblio.org
> > http://lists.ibiblio.org/mailman/listinfo/freetds
> >
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>
>




Archive powered by MHonArc 2.6.24.

Top of Page