Professional Web Applications Themes

#39204 [NEW]: MsSq_Fetch_* return Empty (Var)Char as single space - PHP Bugs

From: bertrand dot lepoittevin at groupe-mma dot fr Operating system: Windows 2000 PHP version: 4.4.4 PHP Bug Type: MSSQL related Bug description: MsSq_Fetch_* return Empty (Var)Char as single space Description: ------------ Hi, When reading Sql Char or Varchar Values which are empty (""), mssql_fetch_* functions returns a single space, instead of returning empty string. According to me this is a bug, right trimming values is just a workaround, and make thing more complicated when we need to compare values (form) and sql values. I know there is old issues of this problem (since PHP v4.3.4), but : - Is it ...

  1. #1

    Default #39204 [NEW]: MsSq_Fetch_* return Empty (Var)Char as single space

    From: bertrand dot lepoittevin at groupe-mma dot fr
    Operating system: Windows 2000
    PHP version: 4.4.4
    PHP Bug Type: MSSQL related
    Bug description: MsSq_Fetch_* return Empty (Var)Char as single space

    Description:
    ------------
    Hi,

    When reading Sql Char or Varchar Values which are empty (""),
    mssql_fetch_* functions returns a single space, instead of returning empty
    string.

    According to me this is a bug, right trimming values is just a workaround,
    and make thing more complicated when we need to compare values (form) and
    sql values.

    I know there is old issues of this problem (since PHP v4.3.4), but :
    - Is it really a ntwdblib.dll bug ? And which V of this file corrects the
    MS bug ?
    - It it possible to avoid this pb in MSSQL APIs ?

    Ref :
    Sql server 8.0, ntwdblib.dll V2000.80.194.0

    Regards.


    --
    Edit bug report at [url]http://bugs.php.net/?id=39204&edit=1[/url]
    --
    Try a CVS snapshot (PHP 4.4): [url]http://bugs.php.net/fix.php?id=39204&r=trysnapshot44[/url]
    Try a CVS snapshot (PHP 5.2): [url]http://bugs.php.net/fix.php?id=39204&r=trysnapshot52[/url]
    Try a CVS snapshot (PHP 6.0): [url]http://bugs.php.net/fix.php?id=39204&r=trysnapshot60[/url]
    Fixed in CVS: [url]http://bugs.php.net/fix.php?id=39204&r=fixedcvs[/url]
    Fixed in release: [url]http://bugs.php.net/fix.php?id=39204&r=alreadyfixed[/url]
    Need backtrace: [url]http://bugs.php.net/fix.php?id=39204&r=needtrace[/url]
    Need Reproduce Script: [url]http://bugs.php.net/fix.php?id=39204&r=needscript[/url]
    Try newer version: [url]http://bugs.php.net/fix.php?id=39204&r=oldversion[/url]
    Not developer issue: [url]http://bugs.php.net/fix.php?id=39204&r=support[/url]
    Expected behavior: [url]http://bugs.php.net/fix.php?id=39204&r=notwrong[/url]
    Not enough info: [url]http://bugs.php.net/fix.php?id=39204&r=notenoughinfo[/url]
    Submitted twice: [url]http://bugs.php.net/fix.php?id=39204&r=submittedtwice[/url]
    register_globals: [url]http://bugs.php.net/fix.php?id=39204&r=globals[/url]
    PHP 3 support discontinued: [url]http://bugs.php.net/fix.php?id=39204&r=php3[/url]
    Daylight Savings: [url]http://bugs.php.net/fix.php?id=39204&r=dst[/url]
    IIS Stability: [url]http://bugs.php.net/fix.php?id=39204&r=isapi[/url]
    Install GNU Sed: [url]http://bugs.php.net/fix.php?id=39204&r=gnused[/url]
    Floating point limitations: [url]http://bugs.php.net/fix.php?id=39204&r=float[/url]
    No Zend Extensions: [url]http://bugs.php.net/fix.php?id=39204&r=nozend[/url]
    MySQL Configuration Error: [url]http://bugs.php.net/fix.php?id=39204&r=mysqlcfg[/url]
    bertrand dot lepoittevin at groupe-mma dot fr Guest

  2. #2

    Default #39204 [Opn->Bgs]: MsSq_Fetch_* return Empty (Var)Char as single space

    ID: 39204
    Updated by: [email]tony2001php.net[/email]
    Reported By: bertrand dot lepoittevin at groupe-mma dot fr
    -Status: Open
    +Status: Bogus
    Bug Type: MSSQL related
    Operating System: Windows 2000
    PHP Version: 4.4.4
    New Comment:

    Sorry, but your problem does not imply a bug in PHP itself. For a
    list of more appropriate places to ask for help using PHP, please
    visit [url]http://www.php.net/support.php[/url] as this bug system is not the
    appropriate forum for asking support questions. Due to the volume
    of reports we can not explain in detail here why your report is not
    a bug. The support channels will be able to provide an explanation
    for you.

    Thank you for your interest in PHP.

    Uprade your ntwdblib.dll and please search in existing bug-reports
    before reporting.


    Previous Comments:
    ------------------------------------------------------------------------

    [2006-10-20 06:55:29] bertrand dot lepoittevin at groupe-mma dot fr

    Description:
    ------------
    Hi,

    When reading Sql Char or Varchar Values which are empty (""),
    mssql_fetch_* functions returns a single space, instead of returning
    empty string.

    According to me this is a bug, right trimming values is just a
    workaround, and make thing more complicated when we need to compare
    values (form) and sql values.

    I know there is old issues of this problem (since PHP v4.3.4), but :
    - Is it really a ntwdblib.dll bug ? And which V of this file corrects
    the MS bug ?
    - It it possible to avoid this pb in MSSQL APIs ?

    Ref :
    Sql server 8.0, ntwdblib.dll V2000.80.194.0

    Regards.



    ------------------------------------------------------------------------


    --
    Edit this bug report at [url]http://bugs.php.net/?id=39204&edit=1[/url]
    tony2001@php.net Guest

  3. #3

    Default #39204 [Bgs]: MsSq_Fetch_* return Empty (Var)Char as single space

    ID: 39204
    User updated by: bertrand dot lepoittevin at groupe-mma dot fr
    Reported By: bertrand dot lepoittevin at groupe-mma dot fr
    Status: Bogus
    Bug Type: MSSQL related
    Operating System: Windows 2000
    PHP Version: 4.4.4
    New Comment:

    Thanx for your quick reply,
    i will try to upgrade ntwdblib.dll.

    Best Regards.


    Previous Comments:
    ------------------------------------------------------------------------

    [2006-10-20 08:56:15] [email]tony2001php.net[/email]

    Sorry, but your problem does not imply a bug in PHP itself. For a
    list of more appropriate places to ask for help using PHP, please
    visit [url]http://www.php.net/support.php[/url] as this bug system is not the
    appropriate forum for asking support questions. Due to the volume
    of reports we can not explain in detail here why your report is not
    a bug. The support channels will be able to provide an explanation
    for you.

    Thank you for your interest in PHP.

    Uprade your ntwdblib.dll and please search in existing bug-reports
    before reporting.

    ------------------------------------------------------------------------

    [2006-10-20 06:55:29] bertrand dot lepoittevin at groupe-mma dot fr

    Description:
    ------------
    Hi,

    When reading Sql Char or Varchar Values which are empty (""),
    mssql_fetch_* functions returns a single space, instead of returning
    empty string.

    According to me this is a bug, right trimming values is just a
    workaround, and make thing more complicated when we need to compare
    values (form) and sql values.

    I know there is old issues of this problem (since PHP v4.3.4), but :
    - Is it really a ntwdblib.dll bug ? And which V of this file corrects
    the MS bug ?
    - It it possible to avoid this pb in MSSQL APIs ?

    Ref :
    Sql server 8.0, ntwdblib.dll V2000.80.194.0

    Regards.



    ------------------------------------------------------------------------


    --
    Edit this bug report at [url]http://bugs.php.net/?id=39204&edit=1[/url]
    bertrand dot lepoittevin at groupe-mma dot fr Guest

Similar Threads

  1. #26315 [Com]: mssql_fectch_* functions are returning a space char on empty fields
    By w1lz0r at barrysworld dot net in forum PHP Development
    Replies: 3
    Last Post: February 26th, 06:54 AM
  2. #26380 [Opn]: empty($SimpleXMLObject) doesn't return true when empty
    By bart at mediawave dot nl in forum PHP Development
    Replies: 0
    Last Post: November 24th, 12:58 PM
  3. Replies: 0
    Last Post: November 19th, 02:44 PM
  4. #26315 [NEW]: mssql_fectch_* functions are returning a space char on empty fields
    By webmaster at cbre dot fr in forum PHP Development
    Replies: 0
    Last Post: November 19th, 12:22 PM
  5. Replies: 0
    Last Post: July 13th, 07:37 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139