Return parameters are double utf-encoded

[f-p-r]

Just doing first steps with IbmiToolkit, i modified call-procedure.php script in samples for testing. It works, but character parameters (ie $params[] = $conn->AddParameterChar('both', 20,'Parm', 'PARM', ''); ) are returned with 'double utf-8 encoding'. That is, i had to perform mb_convert_encoding($result['io_param']['PARM'], 'ISO-8859-1', 'UTF-8') to get the right parameter value in utf-8. I verified that the script is utf-8 encoded, with some special chars hardcoded that show ok in the html result page, which even has defined charset="UTF-8" as meta to make sure it displays content in utf-8 encoding.

Maybe it's a config issue?

[alanseiden]

@f-p-r Could you create a debug log of the program call and post it here? Instructions:

IbmiToolkit/samples/options.php

Line 72 in 8096679

$conn->setOptions(array('debug' => true,

[f-p-r]

Hi. I'm attaching the log file. Notepad++ says it's UT-8 encoded. Maybe the problem is *<?xml version="1.0" encoding="ISO-8859-1" ?> *in Input XML and Output Xml tags? El vie, 15 nov 2024 a las 4:42, Alan Seiden ***@***.***>) escribió:

…

@f-p-r <https://github.com/f-p-r> Could you create a debug log of the program call and post it here? Instructions: https://github.com/zendtech/IbmiToolkit/blob/809667943aecda42ebf46dbdd35cea2bf7f8d33d/samples/options.php#L72 — Reply to this email directly, view it on GitHub <#211 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/APQFQO5OGGSWWHL2FNLQ5332AVURTAVCNFSM6AAAAABRZZNRZKVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDINZXHA4TCMRVGM> . You are receiving this because you were mentioned.Message ID: ***@***.***>

[f-p-r]

Sorry, looks like the attached file of my email is not available in this chat. I copy the contents:

Exec start: 2024-11-15 12:02:35
Version of toolkit front end: 1.9.3
IPC: ''. Control key: *cdata *here
Stmt: call QXMLSERV.iPLUG512K(?,?,?,?) with transport: ibm_db2
Input XML: <?xml version="1.0" encoding="ISO-8859-1" ?>
<script>
<pgm name='PGM' lib='LIB' >
<parm io='in' comment='Entrada'><data var='ENTRADA' type='7p2'>1234.56</data></parm>
<parm comment='Salida'><data var='SALIDA' type='10A' /></parm>
<parm comment='Salida2'><data var='SALIDA2' type='20A'>123asdÑç</data></parm>
</pgm>
</script>
Output XML: <?xml version="1.0" encoding="ISO-8859-1" ?>
<script>
<pgm name='PGM' lib='LIB' >
<parm comment='Salida'>
<data var='SALIDA' type='10A' ><![CDATA[1234.56Ñ]]></data>
</parm>
<parm comment='Salida2'>
<data var='SALIDA2' type='20A'><![CDATA[123asdÑçÑá]]></data>
</parm>
<success><![CDATA[+++ success LIB PGM ]]></success>
</pgm>
</script>
Exec end: 2024-11-15 12:02:35. Seconds to execute: 0.052284002304077.