IBM i

 View Only

Override default JTOpen/IBM Toolbox fo Java character translation

  • 1.  Override default JTOpen/IBM Toolbox fo Java character translation

    InnerCircle
    Posted Tue April 26, 2022 04:41 PM
    Due to user base almost exclusively using MS Windows and therefore Windows-1252 encoding and the incomplete translation of that character set to CCSID 37, some characters are inevitably translated to SUB (0x3F). When querying text fields using JDBC in Java, these get translated to U+0026. That character causes an unmarschalling error in our SOAP services since it is not a valid character for XML. I can do a simple translation of U+0026 to U+FFFD and all is well. Instead of doing this on field by field bases, is there a way to override the character translation at the JDBC level to account for all similar problems in a single spot?

    Thank you

    ------------------------------
    Peter Vazny
    ------------------------------