[fpc-pascal] [PATCH] Add Oid_JSON in pqconnection unit

[Michael Van Canneyt]

On Wed, 4 Mar 2015, silvioprog wrote:

> Hello,
> The patch allows to use this ... :
> 
>     select row_to_json(row(1,'foo'))
> 
> ... instead of this (in this case, the ::text cast avoids the "Missing (compatible) underlying dataset, can not open" error):

I think you better cast it to ftMemo instead of ftString.

The contents of string fields are limited to 8k in fcl-db.
A lot of JSON will be bigger than that.

Since MyDataset.FieldByName('Mymemofield').AsString works as you would expect, there no reason to use string instead of memo fields.

The use of stringlist in jsonscanner is about to be removed, because it adversely affects performance.

Michael.