php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

Bug #27207 mssql_execute
Submitted: 2004-02-10 09:43 UTC Modified: 2004-02-11 12:55 UTC
From: kbirtha at hotmail dot com Assigned:
Status: Not a bug Package: MSSQL related
PHP Version: 4.3.4 OS: windows 2000
Private report: No CVE-ID: None
View Developer Edit
Welcome! If you don't have a Git account, you can't do anything here.
If you reported this bug, you can edit this bug over here.
(description)
Block user comment
Status: Assign to:
Package:
Bug Type:
Summary:
From: kbirtha at hotmail dot com
New email:
PHP Version: OS:

 

 [2004-02-10 09:43 UTC] 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.

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2004-02-10 11:19 UTC] iliaa@php.net 
What was the original length of columns?
 [2004-02-11 12:55 UTC] fmk@php.net 
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.
 
PHP Copyright © 2001-2025 The PHP Group
All rights reserved. 		Last updated: Wed Feb 05 10:01:30 2025 UTC