Problem with schemaadapter and blob filed

0

We have problems with blob-fields. We test a client/Server Project with firedac. At the server we save a query result with a schemaadapter. At the client we load the result from >>server FDSchemaAdapter.SaveToStream(Result, TFDStorageFormat.sfJSON); >>client LStringStream := TStringStream.Create(FDStoredProcGet.Params[1].asBlob); FDSchemaAdapter.LoadFromStream(LStringStream, TFDStorageFormat.sfJSON); It works fine. But if the result is greater than 256kb, we get an error. Invalid json Format. How can we use a result greater than 256kb? Thanks for help.      

Responses (2)
  • Accepted Answer

    Friday, May 11 2018, 10:48 AM - #Permalink
    0

    Any solution for this problem?

    The reply is currently minimized Show
  • Accepted Answer

    Friday, March 23 2018, 01:44 AM - #Permalink
    -1

    We made more tests and find something out. If we take "TStringStream.Create(FDStoredProcGet.Params[1].asWideString);" it will work. Only the special characters are wrong. With "asBlob" it looks like the text will break at 256kb and the rest will start again at position 0. These part overwrite the first 256kb. I hope these information will help to find a solution.

     

    The reply is currently minimized Show
Your Reply

Please login to post a reply.........