From: chenxi at shine dot com dot cn
Operating system: LINUX RedHat9
PHP version: 5.0.2
PHP Bug Type: MSSQL related
Bug description: same strlen of mssql filed value
Description:
------------
Select data from mssql, and get length of the filed value by using
function strlen(), but i got the same output '40', following is field info
and smaple code.
Reproduce code:
---------------
name utName (char) 40
$dbh = @mssql_connect($tnserver_ipaddr, $tnserver_user,
$tnserver_passwd);
if ($dbh) {
$room_num = GetRoomNum();
mssql_select_db("this");
$sql = "SELECT * FROM [dbo].[HotelFolioView] WHERE (RoomNo =
'$room_num')";
$ret = mssql_query($sql);
while ($row = mysql_fetch_array($ret)) {
print strlen($row['name']).'\r\n';
}
mssql_free_result($ret);
}
Expected result:
----------------
4
7
12
8
....
different length
Actual result:
--------------
40
40
40
40
....
all same '40', this is length of filed 'name'
--
Edit bug report at http://bugs.php.net/?id=30644&edit=1
--
Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=30644&r=trysnapshot4
Try a CVS snapshot (php5.0): http://bugs.php.net/fix.php?id=30644&r=trysnapshot50
Try a CVS snapshot (php5.1): http://bugs.php.net/fix.php?id=30644&r=trysnapshot51
Fixed in CVS: http://bugs.php.net/fix.php?id=30644&r=fixedcvs
Fixed in release: http://bugs.php.net/fix.php?id=30644&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=30644&r=needtrace
Need Reproduce Script: http://bugs.php.net/fix.php?id=30644&r=needscript
Try newer version: http://bugs.php.net/fix.php?id=30644&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=30644&r=support
Expected behavior: http://bugs.php.net/fix.php?id=30644&r=notwrong
Not enough info: http://bugs.php.net/fix.php?id=30644&r=notenoughinfo
Submitted twice: http://bugs.php.net/fix.php?id=30644&r=submittedtwice
register_globals: http://bugs.php.net/fix.php?id=30644&r=globals
PHP 3 support discontinued: http://bugs.php.net/fix.php?id=30644&r=php3
Daylight Savings: http://bugs.php.net/fix.php?id=30644&r=dst
IIS Stability: http://bugs.php.net/fix.php?id=30644&r=isapi
Install GNU Sed: http://bugs.php.net/fix.php?id=30644&r=gnused
Floating point limitations: http://bugs.php.net/fix.php?id=30644&r=float
MySQL Configuration Error: http://bugs.php.net/fix.php?id=30644&r=mysqlcfg
