[TYPO3-english] Transferring 4.5.35 til new server

[Michael Schams]

On 23/08/14 00:28, Jens W. Skov wrote:

> I didn't think that was an issue with 4.5 as it works fine on the old server.

Yes, but if the DB server on the new server is not configured to support 
UTF8, the mysql dump you restored is possibly not the same as before.

> I have changed the database tables , but the issue is still the same.

Check the MySQL config file: /etc/mysql/my.cnf
Make sure, the settings are the same on both servers.
Pay attention to things like:

character-set-server = utf8
collation-server = utf8_general_ci

I assume, you have to re-start MySQL and re-create the database if you 
change anything in the config. After that, restore the DB dump.

Also ensure, the global TYPO3 configs are the same (Install Tool) - 
there was something with $TYPO3_CONF_VARS['BE']['forceCharset'] in 4.5.

Maybe, have a look at http://wiki.typo3.org/UTF-8_support for a complete 
description.

If it turns out that your issue has nothing to do with the DB and UTF8, 
please accept my apologies for pushing you in the wrong direction :-)


Cheers
Michael