如何避免Delphi将特殊字符解释为SQL中的参数? [英] How do I avoid Delphi interpreting special characters as parameters in SQL?

问题描述

我想运行带有特殊字符的Sql查询.但是，我不想使用sql参数.有没有一种方法可以运行以下查询?

I want to run a Sql query with special characters in it. However, I don't want to use sql parameters. There is a way to run following query?

SqlString := 'Select * from Table1 where Name LIKE '`1234567890-=\]['';/.,<>?:"{}|+_)(*&^%$#@!~%'
FSQLQuery.SQL.Clear;
FSQLQuery.SQL.Add( SqlString );
FSQLQuery.Open;

由于冒号登录，Delphi将此查询视为已参数化'`1234567890-=] ['';/.,& lt;>?:"{} | + _)(*& ^％$#@！〜％'并抛出(参数'{} | + _没有值)(*& ^％$#@！〜％').

Delphi considers this query as Parameterised due to colon sign in '`1234567890-=]['';/.,<>?:"{}|+_)(*&^%$#@!~%' and throws (No value for parameter '{}|+_)(*&^%$#@!~%').

推荐答案

您应该输入以下内容:

sqlString := 'SELECT * FROM   Table1 WHERE  Name LIKE ''`1234567890-=\]['''';/.,<>?:"{}|+_)(*&^%$#@!~%'' ';
FSQLQuery.ParamCheck := False; //<<It MUST be prior than SetSql.
FSQLQuery.SQL.Clear;
FSQLQuery.SQL.Add( sqlString );
FSQLQuery.Open;

这篇关于如何避免Delphi将特殊字符解释为SQL中的参数?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！