Problem with UTF-8 and swedish åäö
If you have trouble storing åäö in a UTF-8 mysql database.
make sure field, table and database is utf8_general_ci
Check mysql varaibles by running the following mysql command:
SHOW VARIABLES LIKE "character%";
##
Variable_name Value
character_set_client utf8
character_set_connection utf8
character_set_database utf8
character_set_filesystem binary
character_set_results utf8
character_set_server latin1
character_set_system utf8
character_sets_dir /usr/share/mysql/charsets/Make sure the above is UTF-8
try setting utf8 in PHP code:
<?php
mysql_set_charset('utf8');
?>Knowledge keywords: