[TYPO3-core] RFC: Bug #5088: cache is not saved properly because of charset conflict in the database

[Martin Kutschker]

Dmitry Dulepov schrieb:
> Michael Stucki wrote:
>> PS: Can you explain me why $TYPO3_CONF_VARS[SYS][setDBinit] = "SET 
>> NAMES utf8;" changes the connection charset to UTF8 (that's expected) 
>> but adding "CHARACTER SET utf8" behind makes it remain as Latin1?
> 
> Probably a bug... If I remember correctly, SET NAMES is equal to several 
> "SET character_set_xxx=" directives.

SET NAMES x is the same as these three statements:

SET character_set_client = x;
SET character_set_results = x;
SET character_set_connection = x;

"CHARACTER SET utf8" means nothing at all and is no valid command.

Masi