{"id":9233,"date":"2021-05-13T15:17:40","date_gmt":"2021-05-13T22:17:40","guid":{"rendered":"https:\/\/minisoft.com\/support\/?p=9233"},"modified":"2021-05-13T15:17:41","modified_gmt":"2021-05-13T22:17:41","slug":"as-400-iseries-data-type-mismatch-numberformatexception","status":"publish","type":"post","link":"https:\/\/c002.minisoft.com\/support\/as-400-iseries-data-type-mismatch-numberformatexception\/","title":{"rendered":"AS\/400 (iSeries) Data type mismatch &#8211; NumberFormatException"},"content":{"rendered":"\n<p>For iSeries users seeing a <code>Data type mismatch. (class java.lang.NumberFormatException)<\/code> error, adjusting the database connection string to include the correct CCSID will resolve any character set translation issues. For information on where to edit your database connection, consult the following: <a href=\"\/support\/index.php\/where-to-set-up-your-database-connection\/\">Where to Set Up Your Database Connection<\/a><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/minisoft.com\/support\/wp-content\/uploads\/2021\/05\/DataTypeMismatch.png\"><img decoding=\"async\" loading=\"lazy\" width=\"391\" height=\"187\" src=\"https:\/\/minisoft.com\/support\/wp-content\/uploads\/2021\/05\/DataTypeMismatch.png\" alt=\"\" class=\"wp-image-9234\" srcset=\"https:\/\/c002.minisoft.com\/support\/wp-content\/uploads\/2021\/05\/DataTypeMismatch.png 391w, https:\/\/c002.minisoft.com\/support\/wp-content\/uploads\/2021\/05\/DataTypeMismatch-300x143.png 300w, https:\/\/c002.minisoft.com\/support\/wp-content\/uploads\/2021\/05\/DataTypeMismatch-150x72.png 150w\" sizes=\"(max-width: 391px) 100vw, 391px\" \/><\/a><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/minisoft.com\/support\/wp-content\/uploads\/2021\/05\/CCSID.png\"><img decoding=\"async\" loading=\"lazy\" width=\"218\" height=\"75\" src=\"https:\/\/minisoft.com\/support\/wp-content\/uploads\/2021\/05\/CCSID.png\" alt=\"\" class=\"wp-image-9235\" srcset=\"https:\/\/c002.minisoft.com\/support\/wp-content\/uploads\/2021\/05\/CCSID.png 218w, https:\/\/c002.minisoft.com\/support\/wp-content\/uploads\/2021\/05\/CCSID-150x52.png 150w\" sizes=\"(max-width: 218px) 100vw, 218px\" \/><\/a><\/figure>\n\n\n\n<p>For specific CCSID values, consult the following resource: <a href=\"https:\/\/www.ibm.com\/docs\/en\/i\/7.4?topic=information-ccsid-values-defined-i\">https:\/\/www.ibm.com\/docs\/en\/i\/7.4?topic=information-ccsid-values-defined-i<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>For iSeries users seeing a Data type mismatch. (class java.lang.NumberFormatException) error, adjusting the database connection string to include the correct CCSID will resolve any character set translation issues. For information on where to edit your database connection, consult the following: Where to Set Up Your Database Connection For specific CCSID values, consult the following resource: [&hellip;]<\/p>\n","protected":false},"author":75,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[186],"tags":[81,84,427],"_links":{"self":[{"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/posts\/9233"}],"collection":[{"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/users\/75"}],"replies":[{"embeddable":true,"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/comments?post=9233"}],"version-history":[{"count":1,"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/posts\/9233\/revisions"}],"predecessor-version":[{"id":9236,"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/posts\/9233\/revisions\/9236"}],"wp:attachment":[{"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/media?parent=9233"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/categories?post=9233"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/tags?post=9233"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}