My simple code like:
Code: Select all
procedure TForm34.Button1Click(Sender: TObject);
begin
UniQuery1.SQL.Text := 'SELECT "0"';
UniQuery1.Open;
end;
While the same query with apostrophes (single quotes) instead double quotes runs ok.Exception class EMySqlException with message '#42S22Unknown column '0' in 'field list''.
I checked global and session variables sql_mode and there is not ANSI_QUOTES in it.