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.
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?
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)
While the second string uses all cyrillic characters, including 'а' (0x430) and 'р' (0x440) respectively. африканец =
- Bitmasking conversion of CPU ids with Go
- How can I convert text in a cell to a sequence of ascii code values with a separator in Excel 2016 or LibreOffice?
- Get random string element
- Cannot memory-free strings from arbitrary-length array of strings
- How to insert a character after every 2 characters in a string
- Regex to match string containing two names in any order
- Explode each string in a flat array
- Convert a JavaScript statement to a string
- Parse a querystring into an associative array
- Parse a querystring
- "Palindrome recursive function" detects palindromes right but doesn't behave as expected
- Reversing string characters while keeping them in the same position
- SQL - Query to find if a string contains part of the value in Column
- What actually is done when `string::c_str()` is invoked?
- What is the default encoding for C strings?
- String to string compression algorithm?
- Get PHP class property by string
- Find sub string between two capital words in a text
- Best way to split string into lines
- How to remove string before a certain delimiter in R?
- More elegant way to change format of date without multiple variables and substrings
- Partition a string into substrings that all have majority characters
- Error 'A value of type 'dynamic' can't be assigned to a variable of type 'String'.' in Dart 2.2
- split string only on first instance - java
- How do I get a substring of a string in Python?
- Does PHP have a feature like Python's template strings?
- python split string on multiple delimeters without regex
- Find values in data frame that don't contain specific string and replace them in R
- Remove all whitespace in a string
- Get substring between "first two" occurrences of a character