Stored Procedure Issue

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
chinese-param01


if I direct input the chinese in the sql it works
chinese-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.

Hi,

can you create a simple testcase that reproduces this, pls?
I need DDL script for this table(s) and stored procedure, SQL script that fills some values into that table(s) (or your .fdb that contain above data) and http request for receiving values from that function.

pls drop this to support@ for keeping privacy.

I just re-check all, again The issue is the firebird stored input parameter I did not put utf-8. I solved in my side.

1 Like