Bug #14262 Updated: field name in select results strange characters

From: Date: Wed, 28 Nov 2001 09:21:19 +0000
Subject: Bug #14262 Updated: field name in select results strange characters
References: 1  Groups: php.dev 
Request: Send a blank email to php-dev+get-71891@lists.php.net to get a copy of this message 
ID: 14262
User updated by: mlr@interchain.nl
Reported By: mlr@interchain.nl
Status: Assigned
Bug Type: ODBC related
Operating System: Linux 6.1
PHP Version: 4.0.6
Old Assigned To: derick
Assigned To: 
New Comment:

The strange characters displayed were  displayed due to an error in our own ODBC client. 

I still have the wish that the field name isn't limited to 32 but is allocated as needed, but I
have no idea how difficult this is to implement.

Marco


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

[2001-11-28 02:42:26] derick@php.net

Okay, I'm on it.

Derick

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

[2001-11-28 02:39:44] mlr@interchain.nl

Here it is:


<?
        $cnx = odbc_connect("unims","ecw","inter00");
        $query = "select 1 as '123456789 123456789 123456789 123456789 ' from
bedryf;";
        $qid = odbc_exec($cnx,$query);
        echo odbc_field_name($qid,1);
        odbc_close($cnx);
?>


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

[2001-11-28 02:36:15] derick@php.net

Can you post a short script for me?

Derick

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

[2001-11-28 02:31:47] mlr@interchain.nl

You probably don't know the database, as the DBMS is developed in our company (is called UNIMS)
and we have written our own ODBC driver. 

I have checked what our database returns and that is ok (no strange characters). 

I also looked in the php sources, and I think the problem is in the following struct (php_odbc.h) :

typedef struct odbc_result_value {
        char name[32];
        char *value;
        long int vallen;
        SDWORD coltype;
} odbc_result_value; 

But I am not a PHP-developer (yet ;-) )

Kind regards
Marco



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

[2001-11-28 02:24:17] derick@php.net

Which database are you trying to access through ODBC?

Derick

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

The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at
    http://bugs.php.net/?id=14262


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

Thread (10 messages)

« previous php.dev (#71891) next »