1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
|
--TEST--
mysqli_set_charset()
--SKIPIF--
<?php
require_once('skipif.inc');
require_once('skipifemb.inc');
require_once('skipifconnectfailure.inc');
if (version_compare(PHP_VERSION, '5.9.9', '>') == 1) {
die('skip set character set not functional with PHP 6 (fomerly PHP 6 && unicode.semantics=On)');
}
if (!function_exists('mysqli_set_charset'))
die("skip Function not available");
require_once('connect.inc');
if (!$link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket))
die(sprintf("skip Cannot connect, [%d] %s", mysqli_connect_errno(), mysqli_connect_error()));
if (!($res = mysqli_query($link, 'SELECT version() AS server_version')) ||
!($tmp = mysqli_fetch_assoc($res))) {
mysqli_close($link);
die(sprintf("skip Cannot check server version, [%d] %s\n",
mysqli_errno($link), mysqli_error($link)));
}
mysqli_free_result($res);
$version = explode('.', $tmp['server_version']);
if (empty($version)) {
mysqli_close($link);
die(sprintf("skip Cannot check server version, based on '%s'",
$tmp['server_version']));
}
if ($version[0] <= 4 && $version[1] < 1) {
mysqli_close($link);
die(sprintf("skip Requires MySQL Server 4.1+\n"));
}
if ((($res = mysqli_query($link, 'SHOW CHARACTER SET LIKE "latin1"', MYSQLI_STORE_RESULT)) &&
(mysqli_num_rows($res) == 1)) ||
(($res = mysqli_query($link, 'SHOW CHARACTER SET LIKE "latin2"', MYSQLI_STORE_RESULT)) &&
(mysqli_num_rows($res) == 1))
) {
// ok, required latin1 or latin2 are available
mysqli_close($link);
} else {
die(sprintf("skip Requires character set latin1 or latin2\n"));
mysqli_close($link);
}
?>
--FILE--
<?php
require_once("connect.inc");
$tmp = NULL;
$link = NULL;
if (!is_null($tmp = @mysqli_set_charset()))
printf("[001] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp);
if (!is_null($tmp = @mysqli_set_charset($link)))
printf("[002] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp);
if (!is_null($tmp = @mysqli_set_charset($link, $link)))
printf("[003] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp);
require('table.inc');
if (!$res = mysqli_query($link, 'SELECT @@character_set_connection AS charset, @@collation_connection AS collation'))
printf("[007] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
$tmp = mysqli_fetch_assoc($res);
mysqli_free_result($res);
if (!$character_set_connection = $tmp['charset'])
printf("[008] Cannot determine current character set and collation\n");
$new_charset = ('latin1' == $character_set_connection) ? 'latin2' : 'latin1';
if (!$res = mysqli_query($link, sprintf('SHOW CHARACTER SET LIKE "%s"', $new_charset), MYSQLI_STORE_RESULT))
printf("[009] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
if (mysqli_num_rows($res) == 0)
printf("[010] Test will fail, because alternative test character set '%s' seems not supported\n", $new_charset);
if (false !== ($ret = mysqli_set_charset($link, "this is not a valid character set")))
printf("[011] Expecting boolean/false because of invalid character set, got %s/%s\n", gettype($ret), $ret);
mysqli_close($link);
if (!$link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket))
printf("[012] Cannot connect to the server using host=%s, user=%s, passwd=***, dbname=%s, port=%s, socket=%s\n",
$host, $user, $db, $port, $socket);
if (true !== ($ret = mysqli_set_charset($link, $new_charset)))
printf("[013] Expecting boolean/true, got %s/%s\n", gettype($ret), $ret);
if (!$res = mysqli_query($link, 'SELECT @@character_set_connection AS charset, @@collation_connection AS collation'))
printf("[014] [%d] %s\n", mysqli_errno($link), mysqli_error($link));
$tmp = mysqli_fetch_assoc($res);
mysqli_free_result($res);
if ($new_charset !== $tmp['charset'])
printf("[015] Character set not changed? Expecting %s, got %s\n", $new_charset, $tmp['charset']);
if (!$res = mysqli_query($link, "SHOW CHARACTER SET"))
printf("[016] Cannot get list of character sets\n");
while ($tmp = mysqli_fetch_assoc($res)) {
if ('ucs2' == $tmp['Charset'] || 'utf16' == $tmp['Charset'] || 'utf32' == $tmp['Charset'] || 'utf16le' == $tmp['Charset'])
continue;
/* Uncomment to see where it hangs - var_dump($tmp); flush(); */
if (!@mysqli_set_charset($link, $tmp['Charset'])) {
printf("[017] Cannot set character set to '%s', [%d] %s\n", $tmp['Charset'],
mysqli_errno($link), mysqli_error($link));
continue;
}
/* Uncomment to see where it hangs - var_dump($tmp); flush(); */
if (!mysqli_query($link, sprintf("SET NAMES %s", mysqli_real_escape_string($link, $tmp['Charset']))))
printf("[018] Cannot run SET NAMES %s, [%d] %s\n", $tmp['Charset'], mysqli_errno($link), mysqli_error($link));
}
mysqli_free_result($res);
mysqli_close($link);
if (NULL !== ($tmp = mysqli_set_charset($link, $new_charset)))
printf("[016] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp);
print "done!";
?>
--CLEAN--
<?php
require_once("clean_table.inc");
?>
--EXPECTF--
Warning: mysqli_set_charset(): Couldn't fetch mysqli in %s on line %d
done!
|
