I would like that when i do
Code: Select all
MSQuery1.SQL.Text := 'UPDATE MYTABLE SET FIELD= :NEWVALUE';
MSQuery1.ParamByName('NEWVALUE').AsString := '゚ワノラルユナ';
MSQuery1.Execute;
WIthout this nvarchar strings are casted to varchar.
Thanks.
Code: Select all
MSQuery1.SQL.Text := 'UPDATE MYTABLE SET FIELD= :NEWVALUE';
MSQuery1.ParamByName('NEWVALUE').AsString := '゚ワノラルユナ';
MSQuery1.Execute;
Code: Select all
var
FieldType: TFieldType;
begin
MSQuery1.SQL.Text := 'UPDATE MYTABLE SET FIELD = :NEWVALUE';
MSQuery1.ParamByName('NEWVALUE').AsString := '゚ワノラルユナ';
FieldType := MSQuery1.ParamByName('NEWVALUE').DataType; //ftWideString or ftString
MSQuery1.Execute;
end;
Code: Select all
MSQuery1.SQL.Text := 'UPDATE MYTABLE SET FIELD = :NEWVALUE';
MSQuery1.ParamByName('NEWVALUE').AsString := '゚ワノラルユナ';
MSQuery1.ParamByName('NEWVALUE').DataType := ftWideString;
MSQuery1.Execute;
Code: Select all
ParamStringAsAnsiString := False;