php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #50623 odbc_field_name
Submitted: 2009-12-31 14:42 UTC Modified: 2015-04-11 14:40 UTC
Votes:3
Avg. Score:4.7 ± 0.5
Reproduced:3 of 3 (100.0%)
Same Version:2 (66.7%)
Same OS:2 (66.7%)
From: bpelletier at alct dot ca Assigned: cmb (profile)
Status: Closed Package: ODBC related
PHP Version: 5.3.1 OS: Windows XP Pro
Private report: No CVE-ID: None
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: bpelletier at alct dot ca
New email:
PHP Version: OS:

 

 [2009-12-31 14:42 UTC] bpelletier at alct dot ca
Description:
------------
I use odbc_connect to connect to my sql server 2005.

When I want a column where the field name longer than 31 characters, odbc_result cuts the name to 31 characters.

I really need to know how to overrite the struct to have the possibilities to have at least 64 characters.

Thanks for you help.

I see many bugs reporting the same but no solution are proposes.

Reproduce code:
---------------
$requete= "SELECT * FROM Usagers WHERE NomUsager = '" . $p_nomUsager . "';";
$resultat= ExecuterRequete($requete);
ProchainEnregistrement($resultat);

for ($i=1; $i < odbc_num_fields($resultat) + 1; $i++)
    echo odbc_field_name($resultat, $i)." - ";

function ExecuterRequete($p_requete)
    {
    return odbc_exec($_SESSION['BDConnection'], $p_requete); 
    }

function ProchainEnregistrement($p_resultat)
    {
    return odbc_fetch_row($p_resultat);
    }



Expected result:
----------------
I want the full name of the fields.

Actual result:
--------------
NomUsager - NoEmployeALCT - UsagerActif - DerniereLangueUtiliseUsager - MotDePasseUsager - AccesProgrammeGestionALCT - AccesProgrammeInternational - AccesProgrammeFacturation - AccesGestionALCTConsulterEmploy - AccesGestionALCTAjouterEmploye - AccesGestionALCTModifierEmploye - AccesGestionALCTSupprimerEmploy - AccesGestionALCTConsulterRappor - AccesInternationalConsulterClie - AccesInternationalAjouterClient - AccesInternationalModifierClien - AccesInternationalSupprimerClie - AccesInternationalConsulterCont - AccesInternationalAjouterContac - AccesInternationalModifierConta - AccesInternationalSupprimerCont - AccesInternationalConsulterProd - AccesInternationalAjouterProdui - AccesInternationalModifierProdu - AccesInternationalSupprimerProd - AccesInternationalConsulterCour - AccesInternationalAjouterCourti - AccesInternationalModifierCourt - AccesInternationalSupprimerCour - AccesInternationalConsulterComp - AccesInternationalAjouterCompte - AccesInternationalModifierCompt - AccesInternationalSupprimerComp - AccesInternationalConsulterTran - AccesInternationalAjouterTransp - AccesInternationalModifierTrans - AccesInternationalSupprimerTran - AccesInternationalConsulterCont - AccesInternationalAjouterContac - AccesInternationalModifierConta - AccesInternationalSupprimerCont - AccesInternationalConsulterProv - AccesInternationalAjouterProvin - AccesInternationalModifierProvi - AccesInternationalSupprimerProv - AccesInternationalConsulterRapp - AccesInternationalConsulterSoum - AccesInternationalAjouterSoumis - AccesInternationalModifierSoumi - AccesInternationalSupprimerSoum - AccesInternationalConsulterDema - AccesInternationalAjouterDemand - AccesInternationalModifierDeman - AccesInternationalSupprimerDema - AccesInternationalReviserDemand - AccesConfiguration - UsagerAjoutPar - UsagerDateAjout - UsagerDerniereMiseAJourPar - UsagerDerniereMiseAJour -

Warning: odbc_result() [function.odbc-result]: Field AccesGestionALCTSupprimerEmploye not found in C:\wamp\www\FIK_CE\Fonctions_PHP\Utilitaires.php on line 79

Warning: odbc_result() [function.odbc-result]: Field AccesGestionALCTConsulterEmploye not found in C:\wamp\www\FIK_CE\Fonctions_PHP\Utilitaires.php on line 79

Warning: odbc_result() [function.odbc-result]: Field AccesGestionALCTConsulterRapport not found in C:\wamp\www\FIK_CE\Fonctions_PHP\Utilitaires.php on line 79

Warning: odbc_result() [function.odbc-result]: Field AccesInternationalModifierClient not found in C:\wamp\www\FIK_CE\Fonctions_PHP\Utilitaires.php on line 79

Warning: odbc_result() [function.odbc-result]: Field AccesInternationalSupprimerClient not found in C:\wamp\www\FIK_CE\Fonctions_PHP\Utilitaires.php on line 79

Warning: odbc_result() [function.odbc-result]: Field AccesInternationalConsulterClient not found in C:\wamp\www\FIK_CE\Fonctions_PHP\Utilitaires.php on line 79

Warning: odbc_result() [function.odbc-result]: Field AccesInternationalAjouterContactClient not found in C:\wamp\www\FIK_CE\Fonctions_PHP\Utilitaires.php on line 79

...............

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2010-04-16 20:02 UTC] rony_tobins at hotmail dot com
why not bump up char name[32]; to char name[256]; in php_odbc_includes.h?
 [2015-04-11 14:40 UTC] cmb@php.net
-Status: Open +Status: Closed -Assigned To: +Assigned To: cmb
 [2015-04-11 14:40 UTC] cmb@php.net
Thank you for your bug report. This issue has already been fixed
in the latest released version of PHP, which you can download at 
http://www.php.net/downloads.php


 
PHP Copyright © 2001-2025 The PHP Group
All rights reserved.
Last updated: Mon Jul 14 20:01:55 2025 UTC