freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

[freetds] FreeTDS and PHP: empty strings and NVARCHAR

From: Mattia <mattia AT p2pforum.it>
To: freetds AT lists.ibiblio.org
Subject: [freetds] FreeTDS and PHP: empty strings and NVARCHAR
Date: Mon, 4 Jul 2011 12:49:47 +0200

Hi,
yesterday I modified PHP and FreeTDS codes to make them work with empty
strings and nvarchar in stored procedures.

1. The empty_string.patch (against actual cvs of FreeTDS) is like the ct-lib
patch (so datalen==0 is not null).

2. The nvarchar_export.patch defines XSYBNVARCHAR in sybdb.h (to use
with php).

3. The freetds092_with_nvarchar.patch (against php 5.3.6 stable) fixes a
redefinition of type LBYTE to work with actual Freetds cvs and adds support
for type SQLNVARCHAR (to use with mssql_bind function).

The first patch could break the dblib standard so it could remain an
unofficial
patch.

The second one shouldn't cause problems. It could be merged in the main
tree.

I hope I have done something useful.

Regards

--
Mattia

[freetds] FreeTDS and PHP: empty strings and NVARCHAR, Mattia, 07/04/2011
- Re: [freetds] FreeTDS and PHP: empty strings and NVARCHAR, Mattia, 07/04/2011
- Re: [freetds] FreeTDS and PHP: empty strings and NVARCHAR, Frediano Ziglio, 07/07/2011
  - Re: [freetds] FreeTDS and PHP: empty strings and NVARCHAR, Ken Collins, 07/07/2011
  - Re: [freetds] FreeTDS and PHP: empty strings and NVARCHAR, Mattia, 07/09/2011
    - Re: [freetds] FreeTDS and PHP: empty strings and NVARCHAR, Frediano Ziglio, 07/11/2011
      - Re: [freetds] FreeTDS and PHP: empty strings and NVARCHAR, Mattia, 07/11/2011
        
        Re: [freetds] FreeTDS and PHP: empty strings and NVARCHAR, Frediano Ziglio, 07/11/2011
        
        Re: [freetds] FreeTDS and PHP: empty strings and NVARCHAR, Mattia, 07/11/2011
        
        Re: [freetds] FreeTDS and PHP: empty strings and NVARCHAR, Frediano Ziglio, 07/13/2011