search

VBA-tools / VBA-JSON

JSON conversion and parsing for VBA
MIT License
1.74k stars 565 forks source link

Cyrillic display #238

Open anikev opened 2 years ago

anikev commented 2 years ago

Hello, Cyrillic displays like this: { "name": "\u041C\u0412 049 3\u04450,3 \u043F\u0440\u0438\u043F\u043E\u0439 \u043B\u0435\u043D\u0442\u0430 (\u0442\u0440\u0435\u0445\u0441\u043B\u043E\u0439\u043D\u044B\u0439), ", "vendorcode": "\u041C\u04120493.0 } How to fix it?

houghtonap commented 2 years ago

Those \uXXXX are the Unicode code points for your Cyrillic characters, i.e., \u041c. So VBA-JSON created a correct JSON representation of the data. There is nothing to fix. Now we argue whether VBA-JSON should embed the Unicode code points directly, but doing it either way results in a correct JSON representation of the data.

Nick-vanGemeren commented 2 years ago

ECMA-404, the JSON specification, leaves open the choice of escaping (most) Unicode code points. Using escapes results in an ASCII text which can be transmitted or stored without worrying about interference from the local code page, but may not be easily human-readable.

If human-readable text is essential, you can try the solution in pull request #168. If that solves your issue, please close your issue here.