#45445 [Com]: odbc_field_len(), odbc_field_precision(), odbc_field_scale() - don't work

From: Date: Sat, 12 Sep 2009 15:12:38 +0000
Subject: #45445 [Com]: odbc_field_len(), odbc_field_precision(), odbc_field_scale() - don't work
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-142282@lists.php.net to get a copy of this message 
 ID:               45445
 Comment by:       pits_1 at mail dot ru
 Reported By:      BunakovM at meta dot ua
 Status:           Open
 Bug Type:         ODBC related
 Operating System: Windows XP, SP2
 PHP Version:      5.2.6
 New Comment:

Mikhail (Maksim?)!

I can not found ODBC-driver for TransBase 8-(((
Help me? PLS!

See http://www1.transaction.de/transaction/documentation.0.html?&L=1
Are PHP interface realy exist?

Peter S. from Russia, SPb


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

[2008-07-07 10:05:48] BunakovM at meta dot ua

Description:
------------
The functions odbc_field_len(), odbc_field_precision(),
odbc_field_scale() - don't work corractly when use Transbace ODBC driver
in "SELECT ..." SQL-statement.

Reproduce code:
---------------
$con_str = "Driver={Transbase ODBC};Database=MyDB";
$db_conn = odbc_connect($con_str,"user","0")

$query = "SELECT * FROM Tab1";
$res = odbc_exec($db_conn, $query);
$num_fields = odbc_num_fields($res);
for($j=1; $j<=$num_fields; $j++){
  echo odbc_field_name($res,$j);
  echo '<br/>' . odbc_field_type($res,$j);
  echo '<br/>' . odbc_field_len($res,$j);
  echo '<br/>' . odbc_field_precision($res,$j);
  echo '<br/>' . odbc_field_scale($res,$j);
  echo '<br/>' . odbc_result($res,$j);
}

odbc_free_result($res);    // Free Result
odbc_close($db_conn);    // Close Connection

Expected result:
----------------
city_name
varchar
128
?
?
Kiyv

Actual result:
--------------
city_name
varchar
39806880
39770304
39805152
Kiyv


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


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

Thread (7 messages)

« previous php.bugs (#142282) next »