ID: 27207 Updated by: [EMAIL PROTECTED] 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] [EMAIL PROTECTED] 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
