Error in a collation for german characters

Question

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!

Dimitra

Which software are you referring to? – scai Sep 25 '13 at 13:46 — scai, Sep 25 '13 at 13:46

score 2 · Accepted Answer · answered Sep 25 '13 at 13:59

2

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

answered Sep 25 '13 at 13:59

Michael Hampton

244,070
43
506
972

I tried to upgrade it but it seems that I can't. Is there a way to use it somehow else? – Dimitra Micha Sep 25 '13 at 14:48
Sorry, no, you will have to use MySQL 5.6 or higher. – Michael Hampton Sep 25 '13 at 14:51
Do you know if there is a tutorial that I could use to install MySQL 5.6 in my linux debian server? – Dimitra Micha Sep 26 '13 at 10:07

Error in a collation for german characters

1 Answers1