What are the differences between latin1 and iso-8859-1 in PHP and MySQL?

The main difference between latin1 and iso-8859-1 in PHP and MySQL is that they are essentially the same character encoding. In PHP, latin1 is used to represent the ISO-8859-1 character set. However, in MySQL, latin1 is actually a different encoding called latin1_swedish_ci, which can cause compatibility issues when transferring data between PHP and MySQL. To ensure compatibility between PHP and MySQL when using the ISO-8859-1 character set, it is recommended to explicitly set the character set to iso-8859-1 in both PHP and MySQL configurations. 

// Set character set in PHP
mysqli_set_charset($connection, "iso-8859-1");

// Set character set in MySQL
mysqli_query($connection, "SET NAMES 'iso-8859-1'");

Keywords

latin1 iso-8859-1 PHP MySQL character encoding

Related Questions