[TYPO3] Bug? Using UTF-8, 'Ä' in template.constants: Error 102!

[Karsten Dambekalns]

Hi.

Martin Bless wrote:
> I tried and it works! Can't believe it. 1000 thanks to you! 

Ok, that's good. :)

> I don't really have much trust in using all UTF-8. Are there
> more pitfalls to come? Will there be major problems with extensions?

We start *all* sites with pure UTF-8 now. Nothing i worse than having to 
convert later on (although I have done that as well, resulting in 
working websites.. :).

As soon as DB and PHP and the content behave well together, no further 
problems are to be expected.

> I even have been to a bookshop and read about it. Now I think I didn't
> get it right. Do you have a link to online documentation?

http://dev.mysql.com/doc/refman/5.1/en/charset-connection.html

Two examples of what the two set statements do exactly, and if you look 
closely, you'll get the difference.

A SET NAMES 'x'  statement is equivalent to these three statements:
  SET character_set_client = x;
  SET character_set_results = x;
  SET character_set_connection = x;

A SET CHARACTER SET x statement is equivalent to these three statements:
  SET character_set_client = x;
  SET character_set_results = x;
  SET collation_connection = @@collation_database;

Karsten