August 2016
Beginner to intermediate
717 pages
15h 24m
English
MySQL is the most popular open source database. In this recipe, I will tell you how to set UTF-8 as the default encoding for it. Note that if you don't set this encoding in the database configuration, you might get into a situation where LATIN1 is used by default with your UTF-8 encoded data. This will lead to database errors whenever symbols such as € are used. Also, this recipe will save you from the difficulties of converting the database data from LATIN1 to UTF-8, especially when you have some tables encoded in LATIN1 and others in UTF-8.
Make sure that the MySQL database management system and the MySQLdb Python module are installed and you are using the MySQL engine ...
Read now
Unlock full access