Why I got different result from the same hard-coded string value compare to string from db?

Asked Jun 10 '20 at 12:18

Active Jun 10 '20 at 12:22

Viewed 56 times

I have this code

string regex = Convert.ToString(itemDtlValid.Value); 
string input = itemLst.Value;  
string strRegex = "^[a-zA-Z0-9\\r\\t\\n ./?;:\"'`!@#$%^&*()\\[\\]{}_+=|\\\\\\-~,]*$";             
Regex re = new Regex(regex);
int comparer1 = regex.CompareTo(strRegex);
int comparer2 = String.CompareOrdinal(regex, strRegex);

data in the right column is the value that i have in db for itemDtlValid.Value:

itemDtlValid.Value i got from db which have same value as strRegex.

But then when i compare those two strings, comparer1 and comparer2 don't return 0.

Does anyone know why this happen? How to get comparer1 and comparer2 to return 0?

edited Jun 10 '20 at 12:22

stuartd

70,509
14
132
163

asked Jun 10 '20 at 12:18

user3152496

2

Maybe it's about escaping and unescaping. – Trần Hoàn Jun 10 '20 at 12:25
Can you please share the value of `regex - (itemDtlValid.Value)` – Nareen Babu Jun 10 '20 at 12:46
this is the data i have in db for itemDtlValid.Value ^[a-zA-Z0-9\\r\\t\\n ./?;:\"'`!@#$%^&*()\\[\\]{}_+=|\\\\\\-~,]*$ – user3152496 Jun 10 '20 at 12:50
@TrầnHoàn, when I quickwatch itemDtlValid.Value it has same exact value as strRegex – user3152496 Jun 10 '20 at 12:58
I'd suggest reading https://stackoverflow.com/questions/556133/whats-the-in-front-of-a-string-in-c – mjwills Jun 10 '20 at 13:55
I've found the problem, it's true that it's about escaping and unescaping. Thanks all for the response – user3152496 Jun 11 '20 at 03:39

Why I got different result from the same hard-coded string value compare to string from db?

0 Answers0