mORMot Open Source

ttomas

Member

Registered: 2013-03-08

Posts: 135

TNullableUTF8Text return empty string not null

I have TSQLRecord with published TNullableUTF8Text property and inserted some null values.
MultiFieldValues or RetrieveDocVariantArray returns JSON "field_name": '', not "field_name": null.
I checked db with DB Browser for SQLite, fields are NULL in db. This result are for FPC 3.2fix, Win32/64 and Linux64.
I checked select * from table with SynDBExplorer build with Delphi 2007 and Export to JSON returns null as I expect.
Is this a bug or expected for FPC?

Last edited by ttomas (2020-05-23 12:41:15)