generate JSON and strange char

[Thaddy]

yes I missed that. but I test json with my own json code. no excuse in this case.

[jcmontherock]

ecma-262 tells that json script should be in utf-16 encoded and RFC8259 in utf-8 !... In summary it seems that we can use both !...

[Thaddy]

As long as you escape correctly, probably yes.
But I wonder what they have been smoking while basically re-defining a standard.
That is an absolute no-no in engineering circles.
The latest on sqlite.org is obviously written with a wry sense of humor.....
Read it twice and you will get the joke... if you knew about the utf16 part...
JSON is supposed to be a subset of ECMAscript and that is still utf16.
The wry humor comes likely from https://en.wikipedia.org/wiki/Douglas_Crockford himself.

[BrunoK]

Hello,

I've a code for generate json from my data like this:

Code: Pascal  [Select][+][-]

1. .
2. .
3. .
4. //      JSONString := JSON_Main.FormatJSON; replace with
5.      JSONString := JSON_Main.AsJSON;  // No carriage returns thus no trouble with LineEnding.
6. .
7. .
8. .
9.  

watching in  JSONString i found:


ANSISTRING($00007F8A8734A358)^: '{'#$0A'  "query_11" : {'#$0A'    "ServerElement" : {'#$0A'      "FHost" : "192.168.17.51",'#$0A'      "FPort" : 5432,'#$0A'     ,'#$0A'      "FInitialDatabase" : "postgres"'#$0A'    },'#$0A'    "database" : "asda",'#$0A'    "queryBody" : "c2VsZWN0ICogZnJvbSB0ZXJtaW5hbGkK"'#$0A'  }'#$0A'}'

why do I find those characters like ''#$0A' '?

Because JSON_Main.FormatJSON; returns a readable from of JSON stream.

[BrunoK]

Actually, fairly good basic use description of fpjson can be found in the Wiki at https://wiki.freepascal.org/fcl-json

[Thaddy]

NO json.org is the only source. The rest is derived.

[BrunoK]

Actually, fairly good basic use description of fpjson can be found in the Wiki at https://wiki.freepascal.org/fcl-json

This topic was initially about using fpjson in Free Pascal and why there were CR LF in the JSON string.

[Thaddy]

I am aware of that. read my answer better and look at json.org, which you obviously did not: it needs to be escaped. Period.
Next time, check the source. Not the sourcecode but who wrote the specs.

[BrunoK]

I am aware of that. read my answer better and look at json.org, which you obviously did not: it needs to be escaped. Period.
Next time, check the source. Not the sourcecode but who wrote the specs.

On s'en fout.

[bytebites]

And the piece of code that was claimed to be Thaddys was not his originally.

[Thaddy]

I did not claim that code. Maybe you are refering to the wrong subject?
Because I know what I wrote.(that is except when Benny remembers me that I wrote it)
Yes, I used goto, mea culpa...and that code was written originally in turbo basic and more than 40 35 years old.
God bless, your soul, Bob Zale, I still miss you my mentor and guru.