AE 2018 JSON character encoding....

[goose023]

It appears that the JSON support in AE 2018 is somewhat limited.

I have been doing some experimenting and it looks like it will only work with files encoded in Western (Windows Latin 1). When I tried using a UTF-8 encoded file with Hungarian characters they came out all messed up.

Anyone have any ideas?

Chris

[r2-no-d2]

Same problem ) 1251 does not work. utf8 does not work.
https://i.imgur.com/hkcfibZ.jpg

[goose023]

This is what I'm inputting and what I'm getting out...

[Szalam]

I would recommend filing a bug report.

[Kevin-Monahan]

Hi Chris,

Sorry for the frustration. Please file a bug here.

Thanks,
Kevin

[Premiopolis]

Thanks goose023​ & r2-no-d2 for posting.

One partial solution that works in limited circumstances is to to save the JSON encoded as Western (Windows Latin 1)

On Mac OS this approach covers all of goose023's characters except for the double acute accented u: ű

So this hardly not intended as a solution -- r2-no-d2's example characters, for instance, won't work with this approach -- but it got me through a few challenges.

Filing the following bug report:

Concise Problem Statement

JSON data files used in AE Expressions don't handle full UTF-8 charset

Steps to Reproduce the Problem:

1. Create a JSON file with values that include non-standard characters (like åéüÂàñÿåò Kompakt és felhaznát, kisméretü padlótisztitó ű∂ ñÑ ÿåî Ă ă  â Đ đ Ê ê Ơ ơ Ư ư ờ ắ ờ) (non US alphabet w/ accents / diacritics)

2. Use that JSON data in an expression to generate on-screen text (e.g. footage("sample1.json").sourceData)

3. Make sure JSON file is encoded as UTF-8

Results:

Different characters on screen than in JSON file

Expected Results:

Same characters on screen as JSON File

See following Adobe Forums discussions for more detail:

https://forums.adobe.com/message/9904160#9904160

https://forums.adobe.com/message/9927469#9927469

[Arie Stavchansky]

It seems like the UTF-8 for imported JSON files issue was resolved in 15.1.1, but what about double quotes?  If a string value has an escaped double quote, AE 15.1.1 still interprets it as faulty JSON.  Is there a best-practice for inserting double quotes into the string?

Here is a sample:

[

  { "description" : "This is a sample with \"standard\" double quotes" }

]

If you save that as a .json file, and try to import AE will throw an error.  If the escaped double quotes are removed then the .json file imports fine.

Is escaping double-quote characters in JSON not supported by AE?  Single quotes / apostraphe's seem to work.

Thanks,

Arie

[josefm808422]

This problem still exists with large json files. It happens somewhat random. Sometimes it doesn't happen and I can't tell why. All I can say adobe products are never worth their money... truly abysmal software. The worst I ever used.

Trash adobe software has cost 2 people 3 days of work just for figuring out the bug and creating a workaround. The day adobe is replaced by a better product company the world will be a better place.

[Roland Kahlenberg]

1) Are you batch rendering - if yes, approximately how many Comps at one go? 
2) Are you using the new Multiframe Rendering Engine (MFR)? 
3) Have you faced issues if MFR is turned off?

[josefm808422]

1) one comp queued 93 times media encoder with different texts and images
2) yes, and now I tested it with the MFR Emgome off

3) yes, exactly same problem. Non english characters are converted to word salad

[josefm808422]

The json is loaded via extend script and in extend script it's already visible that the text is damage (before inserting it into the textfield). The json is of course UTF8