freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Re: [freetds] FreeTDS and PHP: empty strings and NVARCHAR

From: Frediano Ziglio <freddy77 AT gmail.com>
To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
Subject: Re: [freetds] FreeTDS and PHP: empty strings and NVARCHAR
Date: Wed, 13 Jul 2011 10:08:15 +0200

2011/7/11 Mattia <mattia AT p2pforum.it>:
> 2011/7/11 Frediano Ziglio:
>> However I'm pondering if is not better to pass always strings as
>> unicode.
>
> This is the behavior of the Sql Server's Management Studio.
>
> When will the patch arrive? ;-)
>
> If you need a beta-tester, I'm here.
>

No time to test currently but this should do (src/dblib/rpc.c)

@@ -170,6 +170,9 @@ dbrpcparam(DBPROCESS * dbproc, const char
paramname[], BYTE status, int type, DB
CHECK_CONN(FAIL);
CHECK_PARAMETER(dbproc->rpc, SYBERPCS, FAIL);

+ if (type == SYBVARCHAR && IS_TDS7_PLUS(dbproc->tds_socket))
+ type == XSYBNVARCHAR;
+
/* validate datalen parameter */

if (is_fixed_type(type)) {

freddy77

[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