xref: /php-src/ext/pdo_dblib/tests/types.phpt (revision d6a0b3af)
1--TEST--
2PDO_DBLIB: Column data types, with or without stringifying
3--EXTENSIONS--
4pdo_dblib
5--SKIPIF--
6<?php
7require __DIR__ . '/config.inc';
8getDbConnection();
9?>
10--FILE--
11<?php
12require __DIR__ . '/config.inc';
13
14$db = getDbConnection();
15
16function get_expected_float_string() {
17    global $db;
18
19    switch ($db->getAttribute(PDO::DBLIB_ATTR_TDS_VERSION)) {
20        case '5.0':
21        case '6.0':
22        case '7.0':
23        case '7.1':
24        case '7.2':
25        case '8.0':
26            return '10.500';
27        default:
28            return '10.5';
29    }
30}
31
32$sql = "
33    SELECT
34        'foo' AS [char],
35        CAST('2030-01-01 23:59:59' AS DATETIME) AS [datetime],
36        CAST(0 AS BIT) AS [false],
37        10.500 AS [float],
38        1000 AS [int],
39        CAST(10.500 AS MONEY) AS [money],
40        CAST('1950-01-18 23:00:00' AS SMALLDATETIME) as [smalldatetime],
41        CAST(1 AS BIT) AS [true]
42";
43
44$stmt = $db->query($sql);
45$row = $stmt->fetch(PDO::FETCH_ASSOC);
46
47var_dump($row['char']);
48var_dump($row['datetime']);
49var_dump($row['false']);
50var_dump($row['float']);
51var_dump($row['int']);
52var_dump($row['money']);
53var_dump($row['smalldatetime']);
54var_dump($row['true']);
55
56$db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, true);
57$stmt = $db->query($sql);
58$row = $stmt->fetch(PDO::FETCH_ASSOC);
59
60var_dump($row['char']);
61var_dump($row['datetime']);
62var_dump($row['false']);
63var_dump($row['float'] === get_expected_float_string());
64var_dump($row['int']);
65// var_dump($row['money']); -- the decimal precision varies and it's not clear why
66var_dump($row['smalldatetime']);
67var_dump($row['true']);
68
69?>
70--EXPECT--
71string(3) "foo"
72string(19) "2030-01-01 23:59:59"
73int(0)
74float(10.5)
75int(1000)
76float(10.5)
77string(19) "1950-01-18 23:00:00"
78int(1)
79string(3) "foo"
80string(19) "2030-01-01 23:59:59"
81string(1) "0"
82bool(true)
83string(4) "1000"
84string(19) "1950-01-18 23:00:00"
85string(1) "1"
86