Insert semicolon error string value

How can I avoid a semicolon in a row to insert into an SQL database table?

Example:

Insert Into items(Description)
Values('Anti Surge T; LBC Slow Blow 6.3 x 32mm 7A / 250V');
+3
source share
1 answer

The semicolon in the line should not cause any problems, anyway enclose the string in single quotes in the insert statement.

+3
source

All Articles