1--TEST-- 2PDO Common: Bug #36798 (Error parsing named parameters with queries containing high-ascii chars) 3--SKIPIF-- 4<?php 5if (!extension_loaded('pdo')) die('skip'); 6$dir = getenv('REDIR_TEST_DIR'); 7if (false == $dir) die('skip no driver'); 8require_once $dir . 'pdo_test.inc'; 9PDOTest::skip(); 10 11if (!strncasecmp(getenv('PDOTEST_DSN'), 'oci', strlen('oci'))){ 12 if (!strpos(strtolower(getenv('PDOTEST_DSN')), 'charset=we8mswin1252')) die('skip expected output valid for Oracle with WE8MSWIN1252 character set'); 13} elseif (!strncasecmp(getenv('PDOTEST_DSN'), 'dblib', strlen('dblib'))) { 14 die('skip not for pdo_dblib'); 15} 16 17?> 18--FILE-- 19<?php 20 21if (getenv('REDIR_TEST_DIR') === false) putenv('REDIR_TEST_DIR='.__DIR__ . '/../../pdo/tests/'); 22require_once getenv('REDIR_TEST_DIR') . 'pdo_test.inc'; 23$db = PDOTest::factory(); 24 25@$db->exec("SET NAMES 'LATIN1'"); // needed for PostgreSQL 26$db->exec("CREATE TABLE test (id INTEGER)"); 27$db->exec("INSERT INTO test (id) VALUES (1)"); 28 29$stmt = $db->prepare("SELECT '�' as test FROM test WHERE id = :id"); 30$stmt->execute(array(":id" => 1)); 31 32$row = $stmt->fetch(PDO::FETCH_NUM); 33var_dump( $row ); 34 35?> 36--EXPECT-- 37array(1) { 38 [0]=> 39 string(1) "�" 40} 41
