Error in a collation for german characters

Dimitra Micha asked:

I would like to use the collation utf8_german2_ci in my linux server. The problem is that I want to use this character ß which is not supported in other collation I think. So I get this error ERROR 1273 (HY000): Unknown collation: utf8_german2_ci, which is normal since when I use

show collation like ‘utf8%’

there isn’t this one collation.

Do u know how I could download it or use it?

Thanks in advance!


My answer:

The utf8_german2_ci collation is only available in MySQL 5.6 or higher. Previous versions of MySQL do not contain it.

View the full question and any other answers on Server Fault.

Creative Commons License
This work is licensed under a Creative Commons Attribution-ShareAlike 3.0 Unported License.