Error Read-json - Euro symbol load

[greeshma]

Read-json throws error while reading long char having "€" (Euro symbol).
Error is given below.Please suggest any solution.

Unable to convert JSON to native data type for field ''<field> in temp-table ''<table>. (15363)
The JSON string for the temp-table field was not a valid string representaion for the field's data type.

 

[jongpau]

I believe that is caused because the longchar variable (or your session) has the incorrect code-page set. Check out the fix-codepage statement FIX-CODEPAGE(<longchar variable>) = "<codepage>".

 

[RealHeavyDude]

You don't tell much about your enviroment. But you should be aware that the € Symbol is not part of the most commonly used code page in the western world: iso8859-1. Which of course might cause issue when your session (and/or database) runs with it.

Heavy Regards, RealHeavyDude.