As shown in figure, the same words, the output results of different



The first value from the log log copy
The second value from the database replication

Id1 attributes is as follows:


But the strange thing is, can test most of the other number, only the search results can't find, I do not know whether coding issues
Theoretically utf8mb4 will not affect, and try to utf8 is still the same search results

For bosses to reassure!!!!! Bow!!!!! ~

CodePudding user response:

1, the second SQL end with a semicolon ";" Try;
2, the second SQL conditions after 30 try adding a %,

CodePudding user response:

May because there are not visible characters, it is suggested that take the length () to screen for confirmation

CodePudding user response:

Use single quotation marks

CodePudding user response:

I just met two strings look identical to the naked eye, but there is a string contains a special character, finally through read getByte discovered in Java programs, with length () check it