M
M
Mireille Arov2018-08-17 19:06:05
SQL
Mireille Arov, 2018-08-17 19:06:05

Why did the same text turn out to be different when checking?

Two identical values ​​are taken from two SQL databases. Take a look at the formula above. There are no gaps anywhere. How is this even possible? Maybe different encodings?
5b76f2473b768103256393.png

Answer the question

In order to leave comments, you need to log in

4 answer(s)
D
dollar, 2018-08-17
@makenewworld

Look at the code for each character.
Or programmatically compare strings character by character.

R
Rsa97, 2018-08-17
@Rsa97

ABEKMNORSTHaeopcyx
ABEKMHOPCTXaeopcyx
See the difference between the lines? And there are no matching letters, the top line is Cyrillic, the bottom line is Latin.

X
xmoonlight, 2018-08-17
@xmoonlight

For an example and understanding, you can look at how the fuzzy search for endings works for me: it always tries to bring letters to the same layout.
Here .
Trite: md5() - check the hash sum of strings.

C
CrazyElf, 2018-08-18
@CrazyElf

It also happens that one of the lines has a space at the end, while the other does not have a space. It's hard to see visually.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question