#27207 [Fbk->Bgs]: mssql_execute

From: Date: Wed, 11 Feb 2004 17:55:19 +0000
Subject: #27207 [Fbk->Bgs]: mssql_execute
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-54767@lists.php.net to get a copy of this message 
 ID:               27207
 Updated by:       fmk@php.net
 Reported By:      kbirtha at hotmail dot com
-Status:           Feedback
+Status:           Bogus
 Bug Type:         MSSQL related
 Operating System: windows 2000
 PHP Version:      4.3.4
 New Comment:

The library provided from Microsoft (dblib) has an onl limitation based
on SQL Server 6.x

#define MAXCOLNAMELEN 30

This limitation was changed in laterversions of the SQL server but
dblib was never updated by Microsoft.


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

[2004-02-10 11:19:27] iliaa@php.net

What was the original length of columns? 

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

[2004-02-10 09:43:43] kbirtha at hotmail dot com

Description:
------------
My co-workers and I recently found out that there seems to be a maximum
character limit on column and table names.  This function will return a
true when executing a sql statement successfully, but the recordset
will be empty if the column or table names are too long  We don't know
max number of characters allowed, just know when we shortened the
names, the queries worked.



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


-- 
Edit this bug report at http://bugs.php.net/?id=27207&edit=1

Thread (3 messages)

« previous php.bugs (#54767) next »