What is the recommended charset for storing HTML pages with PHP in a MySQL database?

When storing HTML pages with PHP in a MySQL database, it is recommended to use the UTF-8 character set to ensure compatibility with a wide range of languages and special characters. This will help prevent any encoding issues and ensure that the HTML content is displayed correctly on the website. 

// Set the character set to UTF-8 before storing HTML content in the database
mysqli_set_charset($connection, "utf8");

// Example code to store HTML content in a MySQL database
$html_content = "<html><body><h1>Hello, World!</h1></body></html>";
$html_content = mysqli_real_escape_string($connection, $html_content);

$query = "INSERT INTO html_pages (content) VALUES ('$html_content')";
mysqli_query($connection, $query);

Keywords

PHP MySQL charset HTML pages recommended

Related Questions