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 Add Comment Developer Edit
Welcome! If you don't have a Git account, you can't do anything here.
You can add a comment by following this link or 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

Add a Patch

Pull Requests

Add a Pull Request

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-2024 The PHP Group
All rights reserved. 		Last updated: Wed May 15 14:01:36 2024 UTC