If I understand this correctly: you entered the data through phpMyAdmin, and it shows correctly there. But you query the data from your website, and it doesn’t show it correctly there?
If so:
You’re looking for the right thing, but in the wrong place. Collation affects how data is indexed on disk, but seeing how it is shown differently in different places, collation is not the issue.
I suspect the issue is caused by the database charset of your MySQL connection in PHP. phpMyAdmin uses utf8 (or utf8mb4) for this, but PHP is configured to use latin1 by default. So data entered with phpMyAdmin will be garbled on your site, and vice versa.
To fix this, you should always set the charset of the database connection in your code. utf8mb4 is always a good choice for this.
If you use MySQLi: PHP: mysqli::set_charset - Manual
If you use PDO: PHP: PDO_MYSQL DSN - Manual