Azure, String parameter in TUniQuery lose line feed character
Posted: Wed 07 Jun 2017 11:56
Hello, i have a simple insert into statement which add a new record to a table.
Like :
However, if i read the Text column later via a SQL statement, get i one line of text only instead of the expected two lines. The #13 character is not more there.
if i use a TUniTable and a grid component to enter a multi line text, then work it as expected.
It seems that the #13 character will be removed before or while sending the script. If this is true, why?
Like :
Code: Select all
WorkerQuery.SQL.Text :=
'INSERT INTO Activities (Duration, Text) VALUES (:Duration, :Text)';
WorkerQuery.ParamByName('Duration').AsInteger := 1;
WorkerQuery.ParamByName('Text').AsString := 'First line of text'+#13+'Second line of text';
WorkerQuery.ExecSQL;
if i use a TUniTable and a grid component to enter a multi line text, then work it as expected.
It seems that the #13 character will be removed before or while sending the script. If this is true, why?