开发者

SQL Escape for access database from C#

开发者 https://www.devze.com 2023-03-11 20:28 出处：网络

Which characters need to be escaped before 开发者_高级运维being inserted into a JET Engine data table? I\'m currently just replacing the \' character for this \'\' (this are two \' characters, not a \

相关专题：ms-access ms-jet-ace

Which characters need to be escaped before 开发者_高级运维being inserted into a JET Engine data table? I'm currently just replacing the ' character for this '' (this are two ' characters, not a " character) and it works just fine (I'm quoting the string with the ' character like this 'hello' so I'd turn this: 'don't' into this 'don''t' ).

So far it has been working fine, but is there any other character I need to escape? I'm creating these queries from C# code and executing them with a OleDbCommand.

Edit I know I can use parametrized queries. But I would like to know the answer to the question above.

Rather use parameterized queries. The provider would solve all these issues for you.

Turning ' into '' is enough. Every other character can stay the same.