Recently in web system, found that when the user fill out information basic it is stickup assignment, so it's easy to paste some strange characters, to generate data in the system, affect the overall data, at present is often found, so sqlerver is there any way to recognize and special processing,

CodePudding user response:

Suggest to control when I was on the front end to fill in, or all by database will be very easy to cause congestion,

CodePudding user response:

Now through encode around, then lock the special symbols, when inserted into the database of the special symbol can replace the air

CodePudding user response:

Should be considered in the program end piece, deal with the column at