How does xdata handle Mysql Longtext field types

[Burton_Richard]

I have a couple of tables with field type of Longtext in them, used for storing memos etc. In the json for these fields in has substituted he data with the table and and a proxy message (eg. mat_prc(91606)/MarketNotes)

Should I convert longtext fields to something else or is there another way to handle these.

Thank you

Richard

[wlandgraf (Wagner Landgraf)]

That's how BLOBs work in XData. It's explained in the documentation here:

https://doc.tmssoftware.com/biz/xdata/guide/aurelius.html#addressing-streams-blobs

Alternatively you can use this approach if you don't mind about lazy loading:

XData and PostgreSQL Text Field

That is the text content encoded in Base64. You should get that value and pass it through a Base64 decoder to have your final text. If you don't want or don't need to have your json_field to be lazy-loaded, you can simply map it as a string type. Just make the size 65536 and then it will still be a blob in your database (a text blob, actually) and in XData it will appear inline as raw text: [Column('json_field', [], 65536)] FJsonField: string;