Bug #10889 Updated: mssql_fetch_array - IDENTITY values returned as string with padded NULL chars
| From: | fmk@php.net | Date: | Sat, 30 Jun 2001 19:34:50 +0000 |
| Subject: | Bug #10889 Updated: mssql_fetch_array - IDENTITY values returned as string with padded NULL chars | ||
| Groups: | php.dev | ||
| Request: | Send a blank email to php-dev+get-58564@lists.php.net to get a copy of this message | ||
ID: 10889
Updated by: fmk
Reported By: alt@swiftview.com
Old-Status: Open
Status: Closed
Bug Type: MSSQL related
Operating system:
PHP Version: 4.0.5
Assigned To:
Comments:
Update to php 4.0.6, and use the php.ini setting
mssql.compatability_mode = Off
to specify that you will have all data returned as php types.
Previous Comments:
---------------------------------------------------------------------------
[2001-05-15 17:03:54] alt@swiftview.com
OS = Windows 2000
Server = IIS 5.0
Database = SQL Server 7
PHP = 4.0.5
To reproduce
1. Create a table as such:
CREATE TABLE table1 (
row_id NUMERIC(9,0) IDENTITY,
col1 INT NOT NULL,
col2 INT NULL,
col3 VARCHAR(25) NULL,
PRIMARY KEY(row_id)
)
GO
2. Insert a row:
INSERT INTO table1 (col1) VALUES(1)
GO
3. Now fetch that row
<?php
$hostname = "<your hostname here>";
$username = "<your username here>";
$password = "<your password here>";
$dbName = "<your database name here>";
// Connect
$connectionID = mssql_connect($hostname, $username, $password);
$retval = mssql_select_db($dbName);
// Query
$query = "SELECT row_id, col1, col2, col3 from table1"
$queryID = mssql_query($query, $connectionID)
// Fetch fields
$fields = mssql_fetch_array($queryID);
list($row_id, $col1, $col2, $col3) = $fields;
echo "type = " . gettype($row_id) . "<br>";
echo "strlen($row_id) = " . strlen($row_id) . "<br>";
echo bin2hex($row_id) . "<br>";
mssql_close($connectionID);
?>
3. Results
Did yours match mine? My result from bin2hex is
310000000000000000000000000000000000000000
The character 1, followed by 19 nulls!
---------------------------------------------------------------------------
ATTENTION! Do NOT reply to this email!
To reply, use the web interface found at http://bugs.php.net/?id=10889&edit=2