Focal Point
[CLOSED] JSON Encoding Problem

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/7417038586

March 13, 2017, 05:07 PM
Amom
[CLOSED] JSON Encoding Problem
Dear all,

I'm having some issues with encoding of JSON output.
If I run some fex in JSON format that data has special characters (ã,á, etc...) through App Studio, the json file works fine.
But if I run this fex from the Webfocus client (i.e., ajax get request), special characters go wrong...
Other formats, as dfix, works fine...

My environment:
Version: 8105m
Webfocus server: 137 (ISO-8859-1)
Webfocus client: 137 (ISO-8859-1)
Unix Server: ISO-8859-1

Thanks in advance,

Regards,
A.

This message has been edited. Last edited by: FP Mod Chuck,


WebFOCUS 8
Windows, All Outputs
March 13, 2017, 05:14 PM
Waz
How do the characters go wrong ?

Could it be a codepage difference ?


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

March 15, 2017, 10:13 AM
Amom
Hello Waz!
Thank you by answer.

For example, words with character "ã" returns à in the JSON file.

It seems that the report server tries to convert ISO-8859-1 to UTF-8.


WebFOCUS 8
Windows, All Outputs
March 15, 2017, 11:31 AM
Francis Mariani
I would make sure the reporting and client servers are set to the appropriate code page.

Client Server (Admin Console)



Reporting Server




Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
March 15, 2017, 12:03 PM
Francis Mariani
And also your web server, Tomcat perhaps...

https://wiki.apache.org/tomcat/FAQ/CharacterEncoding


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server