Bug #81688 [Com]: PDO_ODBC doesn't handle fixed-length character columns with character conversio

Edit report at https://bugs.php.net/bug.php?id=81688&edit=1 ID: 81688 Comment by: calvin at cmpct dot info Reported by: calvin at cmpct dot info Summary: PDO_ODBC doesn't handle fixed-length character columns with character conversio Status: No Feedback Type: Bug Package: PDO ODBC Operating System: IBM i 7.2 PHP Version: 8.0.13 Assigned To: cmb Block user comment: N Private report: N New Comment: The problem still exists, it should be re-opened. That said, I'm not entirely sure of the etiquette though around bugs on bugs.php; are these better off moved to GH Issues instead now? Previous Comments: ------------------------------------------------------------------------ [2021-12-26 04:22:08] php-bugs at lists dot php dot net No feedback was provided. The bug is being suspended because we assume that you are no longer experiencing the problem. If this is not the case and you are able to provide the information that was requested earlier, please do so and change the status of the bug back to "Re-Opened". Thank you. ------------------------------------------------------------------------ [2021-12-14 18:53:44] calvin at cmpct dot info I can confirm that PDO::ODBC_ATTR_ASSUME_UTF8 and using the procedural ODBC extension have the same results. (Well, the garbage on the end is different, but it's still garbage and the string is still the same length.) Code for the procedural ODBC version (the attrib on PDO ver is trivial so not including): ``` $odbc = odbc_connect($dsn, $user, $pw); $sql = "select cast(x as char(150)) as X from calvin.bigchars"; $stmt = odbc_prepare($odbc, $sql); echo "before ODBC\n"; var_dump(odbc_execute($stmt)); echo "after ODBC\n"; while($record = odbc_fetch_array($stmt)){ echo "Record\n"; var_dump($record["X"]); } ``` ------------------------------------------------------------------------ [2021-12-14 13:47:41] cmb@php.net Oh, forgot: could you also please check the results of the queries with ext/odbc (i.e. the odbc_*() functions)? The implementation is quite different from PDO_ODBC. ------------------------------------------------------------------------ [2021-12-14 13:11:03] cmb@php.net > Of course, the link to the Appendix isn't any more enlightening: Yeah. :( Anyhow, all this looks remotely related to bug #79059; see particularly my last comment there[1]. It might be worthwhile to try to run the scripts with PDO::ODBC_ATTR_ASSUME_UTF8 set to true, even though that is not yet consistently implemented. [1] <https://bugs.php.net/bug.php?id=79059#1601993047> ------------------------------------------------------------------------ [2021-12-07 16:54:56] calvin at cmpct dot info Interesting observation: if you try to cast so PHP picks a bigger buffer size that might be able to accommodate the conversion, you still get garbage at the end: i.e. select cast(x as char(150)) as X from calvin.bigchars gets you ``` Record string(180) "éééééééééééééééééééééééééééééé 0 (*Wind!@.0*) Gecko* " Record string(165) "ééééééééééééééé 0 (*Windo" Record string(155) "ééééé 0 (*" ``` (I'm guessing that's garbage in memory left over from parsing browscap, since this is CLI...) ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at https://bugs.php.net/bug.php?id=81688 -- Edit this bug report at https://bugs.php.net/bug.php?id=81688&edit=1