The scenario: An html-document that's used for editing product details is encoded as ISO-8859-1, and sends POST data to a PHP-file (also encoded ISO-8859-1). That PHP-file in turn has mysql_real_escape_string -functions cleaning the inputs. The database/mysql server charset is UTF-8. The problem is that when a POST string has scandinavian letters (ä,ö,å) in it, the mysql_real_escape_string returns an empty string.
I tried to override it with utf8_encode/decode, but it won't work.
Now, if I change the html&php-files to use UTF-8, saving works fine (as expected), but then all previously saved product data looks corrupt, and there are thousands of product rows.
What would be the easiest solution to fix it? Change the db charset? Run a encoding function to convert the entries in the db?
