I need to compare two strings. One of them gets selected out of MySQL and the other one is provided through a textField from the User.
Both strings look like the same but my boolean property won’t turn true, so I converted them to their hex values and one of them has exactly one different byte/character.
How can I prevent this and what could call this issue?
Where can I see the text encoding or how can I proof if it is the same? I already read about some similiar problem like mine but I couldn’t come up with a solution.
Var result1 As String
result1 = TextField1.Value.ConvertEncoding(Encodings.UTF8) // use whaterver encoding is best for your project
Var result2 As String
result2 = TextField2.Value.ConvertEncoding(Encodings.UTF8) // use whaterver encoding is best for your project
// use your comparison code on result1 & result2