when I insert table, value is a string contains apostrophe - it throws an error there

[tvnaidu]

When I do INSERT like below, value is a string with apastrophe (for ex: "Checking for 'hlt' instruction"), insert throws an error - how to fix?

INSERT INTO table_name (column1, column2, column3,...)
VALUES (value1, value2, value3,...)

[ck9663]

Remove those quotes. If you need, replace it with something else. Then replace it back when you're retrieving it.

Happy Coding!!!

~~ CK

[JonathanVH]

This should only be an issue if you're using string literals in a script, in which case you can double the single quotes in the string, e.g.:

INSERT dbo.table_name(column1)
VALUES('Checking for ''hit'' instruction');

Based on your using double quotes around the value and calling its data type a "string," I infer that this value is coming from your front-end programming language, in which case you should use parameterized commands, be they text or stored procedures, as that will both obviate such issues and guard against SQL injection attacks.

[tvnaidu]

Thanks, actually this is using lua script, I found an escape sequence to do that, I fixed this. thanks.