Problem with schemaadapter and blob filed
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.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.
Any solution for this problem?
We made more tests and find something out. If we take "TStringStream.Create(FDStoredProcGet.Params.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.