Re: HTTPPOSTBLOBVERBOSE

Am 08.11.2023 um 20:32 schrieb Jimmy Sansi <jsansi@xxxxxxxxx>:
Whatever CCSID I try to cast to ... I get the error message: Character
conversion between CCSID 65535 and CCSID xxxx not valid.

On 2023-11-08 09:32, Daniel Gross wrote:

Hi,

Am 08.11.2023 um 17:50 schrieb Jimmy Sansi <jsansi@xxxxxxxxx>:
Daniel--- The RESPONSEHTTPHEADER is good with Status 200 OK. Also when
running in ACS I know the return hex is valid because I can paste it
into Notepad++ and convert Hex to ASCII and get the JSON results I'm
expecting.

So this seems to confirm my idea, that you simply have to select the correct CCSID.

CLOBs and VARCHARs implicitly have a CCSID - so you can cast them without problems.

But BLOBs do not have a CCSID - they are binary objects. So if you know, that there is "ASCII" text in the BLOB you can try to cast using the correct CCSID.

Just play around with TRY_CAST and different CCSIDs - I would try 1208 (UTF-8), 1200 (UTF-16) and 367 (US-ASCII) first - you probably will find the correct one pretty fast.

-> https://www.ibm.com/docs/en/i/7.5?topic=expressions-try-cast-specification

-> https://www.ibm.com/docs/en/i/7.5?topic=information-ccsid-values-defined-i

HTH
Daniel

--
This is the RPG programming on IBM i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.