[TYPO3-english] UTF-8 wiki - setDBinit

[Steffen Müller]

Hi.

On 30.04.2009 23:06 Jan Bednarik wrote:
> for long time I use:
> 
> SET NAMES utf8
> SET CHARACTER SET utf8
> SET character_set_results=utf8
> SET character_set_connection=utf8
> SET character_set_client=utf8

The more danger, the more honor ;-)
This confuses unexperienced users without need.

SET NAMES utf8;
is an equivalent to
SET character_set_results=utf8;
SET character_set_connection=utf8;
SET character_set_client=utf8;

SET CHARACTER SET utf8;
is an equivalent to
SET character_set_client = utf8;
SET character_set_results = utf8;
SET collation_connection = @@collation_database;
(the latter includes SET character_set_connection =
@@character_set_database;)

This is valid for MySQL 5.0 and 5.1. I don't know about 4.x, which is
anyway not supported anymore.

-- 
cheers,
Steffen

http://www.t3node.com/