bug69354.phpt 845 B

12345678910111213141516171819202122232425262728293031323334353637383940414243
  1. --TEST--
  2. Bug #69354 Incorrect use of SQLColAttributes with ODBC 3.0
  3. --SKIPIF--
  4. <?php include 'skipif.inc'; ?>
  5. --FILE--
  6. <?php
  7. include 'config.inc';
  8. $conn = odbc_connect($dsn, $user, $pass);
  9. @odbc_exec($conn, 'CREATE DATABASE odbcTEST');
  10. odbc_exec($conn, 'CREATE TABLE FOO (ID INT, VARCHAR_COL VARCHAR(100))');
  11. odbc_exec($conn, "INSERT INTO FOO(ID, VARCHAR_COL) VALUES (1, '" . str_repeat("a", 100) . "')");
  12. $res = odbc_exec($conn,"select VARCHAR_COL from FOO");
  13. if ($res) {
  14. if (odbc_fetch_row($res)) {
  15. $ret = odbc_result($res,'varchar_col');
  16. echo strlen($ret), "\n";
  17. echo $ret[0], "\n";
  18. echo $ret[strlen($ret)-1], "\n";
  19. }
  20. }
  21. ?>
  22. ==DONE==
  23. --EXPECT--
  24. 100
  25. a
  26. a
  27. ==DONE==
  28. --CLEAN--
  29. <?php
  30. include 'config.inc';
  31. $conn = odbc_connect($dsn, $user, $pass);
  32. odbc_exec($conn, 'DROP TABLE FOO');
  33. odbc_exec($conn, 'DROP DATABASE odbcTEST');
  34. ?>