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

ID: 14262 User updated by: mlr@interchain.nl Reported By: mlr@interchain.nl Old Status: Feedback Status: Open Bug Type: ODBC related Operating System: Linux 6.1 PHP Version: 4.0.6 New Comment: 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); ?> Previous Comments: ------------------------------------------------------------------------ [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 ------------------------------------------------------------------------ [2001-11-28 01:44:31] mlr@interchain.nl I have the following situation, I execute the following select: select 1 as '123456789 123456789 123456789 123456789' from table; when I display the field names the first 32 characters are ok, the rest of the string displayed are strange characters. Kind regards Marco Laponder (mlr@interchain.nl) ------------------------------------------------------------------------ Edit this bug report at http://bugs.php.net/?id=14262&edit=1