CODEWITHSUNDEEP
stringcharacter-encodingencodeextended-asciicharacter-set
Karlomanio
Karlomanio

Reputation: 371

Differentiate two Cyrillic strings

When I run a query for this string in SQLite with these entries in Cyrillic in a text field, I only find one.

enter image description here

When I put the two strings in two different cells in Excel and search, it only finds the one I copied and pasted in the search prompt. aфpиканeц африканец

I tried checking the encoding on these strings too, but both of them are UTF-8 according to the tools I tried in.

What am I missing? Why does Excel and the SQLite DB don't see them as the same string?

Upvotes: 1

Views: 23

Answers (1)

ipodtouch0218
ipodtouch0218

Reputation: 3346

Excel and SQL see them as different strings because they are different strings. The first string aфpиканeц uses latin characters for the 'a' (0x61) and 'p' (0x70): (note the lack of encoding for them)

enter image description here

While the second string uses all cyrillic characters, including 'а' (0x430) and 'р' (0x440) respectively. африканец =

enter image description here

Upvotes: 1

Related Questions