Re: Special character euro sign in JSON string
> On 12 Jun 2019, at 14:47, Piotr Chabot Stadhouders via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > So, the problem is with JSON in Oracle and WE8ISO8859P1 > Unfortunately knowing this doesn't solve my problem Hi Piotr, For data exchange JSON should be encoded in UTF-8. Any other character set is wrong. Follow that rule and you will not have problems. Kind regards, - Rob Laveaux Pluggers Software Scholekstersingel 48 2496 MP Den Haag The Netherlands Email: rob.lave...@pluggers.nl Website: http://www.pluggers.nl ** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
RE: Special character euro sign in JSON string
Hi Miyako, We use Oracle to generate the JSON, and use as character set WE8ISO8859P1 Although everything else works fine with this charset (also the euro sign), it seems that with JSON Oracle converts the euro sign to \u0080 when using WE8ISO8859P1 instead of \u20AC So, the problem is with JSON in Oracle and WE8ISO8859P1 Unfortunately knowing this doesn't solve my problem Gr, Piotr > -Oorspronkelijk bericht- > Van: Keisuke Miyako > Verzonden: dinsdag 11 juni 2019 10:03 > Aan: 4D iNug Technical <4d_tech@lists.4d.com> > Onderwerp: Re: Special character euro sign in JSON string > > JSON string should be represented in unicode > > https://www.json.org > > \u0080 is not the euro sign. > > $euro:=JSON Parse("{\"euro\":\"\\u20AC\"}") > > > 2019/06/11 16:22、Piotr Chabot Stadhouders via 4D_Tech > <4d_tech@lists.4d.com>のメール: > > When I use $obj:=JSON Parse($json_string) I don't get the euro sign > > returned Does anybody know what the problem is? > > > ** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
Re: Special character euro sign in JSON string
JSON string should be represented in unicode https://www.json.org \u0080 is not the euro sign. $euro:=JSON Parse("{\"euro\":\"\\u20AC\"}") > 2019/06/11 16:22、Piotr Chabot Stadhouders via 4D_Tech > <4d_tech@lists.4d.com>のメール: > When I use $obj:=JSON Parse($json_string) I don't get the euro sign returned > Does anybody know what the problem is? ** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **