Re: Searching database for strings with Swedish characters

[Rick James]

Recommend using a cmd window (if you are in Windows), and typing
mysql
That will bring you to this prompt:
mysql>
which will let you type and execute SQL statements such as
SHOW DATABASES;
USE db_name; -- fill in with the name of the TNG database
SHOW TABLES;
SHOW CREATE TABLE tbl_name; -- the name of the table.
Then identify which column has the characters that are in trouble, and do
SELECT col_name, HEX(col_name) FROM tbl_name;
You may need a WHERE clause on the end to limit it to the one row in question. See if this helps:
SELECT col_name, HEX(col_name) FROM tbl_name WHERE col_name LIKE '%llstad%';

This discusses more than you want to know about problems like yours:
http://mysql.rjweb.org/doc.php/charcoll