freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
- From: Ola Karlsson <olka AT bagheera.se>
- To: "freetds AT lists.ibiblio.org" <freetds AT lists.ibiblio.org>
- Subject: [freetds] Problem with nvarchar output
- Date: Sun, 6 Jul 2014 13:32:58 +0000
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] Problem with nvarchar output,
Ola Karlsson, 07/06/2014
-
Re: [freetds] Problem with nvarchar output,
James K. Lowden, 07/07/2014
-
Re: [freetds] Problem with nvarchar output,
Ola Karlsson, 07/08/2014
- Re: [freetds] Problem with nvarchar output, Thomas, Christopher (LLU), 07/08/2014
-
Re: [freetds] Problem with nvarchar output,
Ola Karlsson, 07/08/2014
-
Re: [freetds] Problem with nvarchar output,
Frediano Ziglio, 07/12/2014
-
Re: [freetds] Problem with nvarchar output,
Ola Karlsson, 07/31/2014
-
Re: [freetds] Problem with nvarchar output,
Frediano Ziglio, 07/31/2014
- Re: [freetds] Problem with nvarchar output, Ola Karlsson, 07/31/2014
-
Re: [freetds] Problem with nvarchar output,
Frediano Ziglio, 07/31/2014
-
Re: [freetds] Problem with nvarchar output,
Ola Karlsson, 07/31/2014
-
Re: [freetds] Problem with nvarchar output,
James K. Lowden, 07/07/2014
Archive powered by MHonArc 2.6.24.