MySQL | How to support European characters on database level

Author - Parminder Kaur

European characters like è é å ñ ü ,à, è, ì, ò, ù – À, È, Ì, Ò, Ù, ™, © ,• , ∑, α, β, «, » do not get inserted correctly in MySQL by default. To fix it, we need to change the character set (fixed collection of symbols) and collation (set of rules that determine how data is sorted and compared).

To insert and retrieve european characters change character set to utf-8 and collation to utf_unicode_ci for your database using SQL query:

ALTER DATABASE  CHARACTER SET utf8 COLLATE utf8_unicode_ci;

UTF-8 (Unicode) includes all human language symbols eg. chinese characters, arabic alphabet , european characters etc and also math symbols.

We can check the character set and collation for all databases in phpmyadmin by following the path:

phpmyadmin>information_schema>schemata

Webner Solutions is a Software Development company focused on developing CRM apps (Salesforce, Zoho), LMS Apps (Moodle/Totara), Websites and Mobile apps. If you need Web development or any other software development assistance please contact us at webdevelopment@webners.com

Webner Solutions is a Software Development company focused on developing Insurance Agency Management Systems, Learning Management Systems and Salesforce apps. Contact us at dev@webners.com for your Insurance, eLearning and Salesforce applications.

Leave a Reply

Your email address will not be published. Required fields are marked *