ID: 14262 User updated by: [EMAIL PROTECTED] Reported By: [EMAIL PROTECTED] 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] [EMAIL PROTECTED] Can you post a short script for me? Derick ------------------------------------------------------------------------ [2001-11-28 02:31:47] [EMAIL PROTECTED] 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] [EMAIL PROTECTED] Which database are you trying to access through ODBC? Derick ------------------------------------------------------------------------ [2001-11-28 01:44:31] [EMAIL PROTECTED] 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 ([EMAIL PROTECTED]) ------------------------------------------------------------------------ Edit this bug report at http://bugs.php.net/?id=14262&edit=1 -- PHP Development Mailing List <http://www.php.net/> To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]