Hi,
delphi 10.4.1
RO/DA: 10.0.0.1495
DB : firbird
Driver:Server=FireDAC?AuxDriver=FB;
when I put the stored proccedure as dataset and input chinese in the param and preview data in the schema. It show Malformed string error. as attached
if I direct input the chinese in the sql it works
Also if I use a server function and use below code and input chinese word also fail with same maformed string error
function TAllTableService.GetQuickCmNoTel(const SIN1,SIN2: UnicodeString): Binary;
var ds:IDADataset;
sjoson:TDAJSONDataStreamer;
begin
Result := TROHttpApiResult.Create(HTTP_200_code, id_ContentType_application_json_charset_utf8,'',false);
ds:=AllTableDASchema.NewDataset(Connection,'QUICK_CM_TBL_NOTEL',['IN1','IN2'],[SIN1, SIN2]);
ds.Open;
sjoson:=TDAJSONDataStreamer.Create(Self);
sjoson.Initialize(Result,aiwrite);
try
sjoson.WriteDataset(ds, [woSchema, woRows], -1);
finally
sjoson.Finalize;
end;
end;
Please advise.