Question error :com.sun.org.apache.xerces.internal.impl.io.MalformedByteSequenceException

Hello,

I have this error when I execute an sql to parameters, with accents in a string value.
Example of the script :

<sqlToParameters>
<parameter name="../p_custtype_code" type="String">
select
case
when '${~/BusinessUnitCode}$' = '1' then 'réassort'
end
from %x{$MYTABLE/tech:physicalPath()}x%
</parameter>
</sqlToParameters>

Because of the accent (é) in 'réassort', I have the error : com.sun.org.apache.xerces.internal.impl.io.MalformedByteSequenceException: Octet 2 de la séquence UTF-8 à 3 octets non valide.
I only have this error when executing the sql to parameters on a runtime on windows. With a same version runtime on unix, I don't have the error.

Runtime version : S17.6.5

How could I fix this?

Thanks.

Hi,

The expression for the Sql To Parameters is based on XML.
XML often requires special characters to be encoded.
Try to replace "é" with "é" and it should work.

I think that the error does not occur on Linux because it is not the same java vendor / version.

Note : we plan to provide in the future a new version of this Sql To Parameters action which will not have this kind of requirement.

Hello,

It does work when using
Thanks

Sylvie