[TYPO3-dev] Re: [TYPO3] Call for problems: MySQL 5 in TYPO3

[Erich Schreiber]

On Mon, 24 Dec 2007 18:07:39 +0200, "Dmitry Dulepov [typo3]"
<dmitry at typo3.org> wrote:

>Hi all!
>
>(This is a cross-post to "english" and "dev" lists. I decided to make a cross-post because this topic is important)
>
>I make myself a new server. It is going to use MySQL 5. I remember that TYPO3 have problems with MySQL 5. If you experienced any, tell me about them in this thread (preferable in "dev" list!) and I will try to fix them until release of 4.2.

Hi

The collation should be set correctly away from the default
(latin1_swedish_ci) on installation of Typo3 (to either
utf8_general_ci or utf8_unicode_ci). 

See: http://dev.mysql.com/doc/refman/5.1/en/charset-unicode-sets.html

Perhaps there can be even an option where one can explicitly choose.
Here is the link to the appropriate section of the MySQL 5.1 manual:
http://dev.mysql.com/doc/refman/5.1/en/internationalization-localization.html

While a wrong collation is probably no problem for the basic Typo3
installation, there might be situations where one has to rely on the
correct sort order of text strings.

Here an example what might happen, also from the MySQL manual:
http://dev.mysql.com/doc/refman/5.1/en/charset-collation-effect.html

Erich