I have a small ajax application built with php.
Using phpMyAdmin I have set a mysql database to utf-8, and have imported a textfile containing utf-8 data into it.
This worked fine on a windows machine with easyphp, after adding character-set-server=utf8 and default-character-set=utf8 to the my.cnf file.
I have now tried to move this to a production server where I do not have access to the configuration file, and characters such as umlauts are not displayed.
Is there something that can be set in the php code(not the configuration file) to fix this, or some command I can give to mysql?
I tried ALTER DATABASE vweb_50
DEFAULT CHARACTER SET utf8 COLLATE utf8_bin with phpMyAdmin to try from utf8_general_ci but it made no difference.