Which collation is best to use in MySQL for a PHP project? Problems with Russian characters

Hello everyone! I'm a beginner in PHP and MySQL, and I'm having a serious problem with displaying Russian characters. \n\nI have a simple registration form in PHP. When a user enters a name in Russian (e.g., "Иван"), it gets saved in the database as "?????" or "Р�ван". I've already tried a bunch of settings, but nothing helps.\n\nHere is my database connection code:\n\n```php\n$db = new mysqli('localhost', 'root', '', 'mydb');\n$db->query("SET NAMES 'utf8'");\n```\n\nAnd the table structure:\n\n```sql\nCREATE TABLE users (\n id INT AUTO_INCREMENT PRIMARY KEY,\n name VARCHAR(100),\n email VARCHAR(100)\n) DEFAULT CHARSET=utf8;\n```\n\nI insert data like this:\n\n```php\n$name = $_POST['name'];\n$stmt = $db->prepare("INSERT INTO users (name, email) VALUES (?, ?)");\n$stmt->bind_param("ss", $na