Re: Problem with nvarchar output

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 <[email protected]>:

> 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:[email protected]] 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 <[email protected]>:
>
> > 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
> > [email protected]
> > http://lists.ibiblio.org/mailman/listinfo/freetds
> >
> _______________________________________________
> FreeTDS mailing list
> [email protected]
> http://lists.ibiblio.org/mailman/listinfo/freetds
>
> _______________________________________________
> FreeTDS mailing list
> [email protected]
> http://lists.ibiblio.org/mailman/listinfo/freetds
>
>
_______________________________________________
FreeTDS mailing list
[email protected]
http://lists.ibiblio.org/mailman/listinfo/freetds