1

I am working on wordpress and wamp combination. WordPress will be used for online shop/delivery service, and will be initially in 3 languages English, Russian and Vietnamese.

For MySql database I am thinking I should use utf16_general_ci collation which should cover all the characters in languages above, still I have never worked on a project like this.

Which collision should I choose not to run into weird sorting issues later on?

Matas Vaitkevicius
  • 58,075
  • 31
  • 238
  • 265
  • Possible duplicate of [MySQL collation to store multilingual data of unknown language](https://stackoverflow.com/questions/4288006/mysql-collation-to-store-multilingual-data-of-unknown-language) – Jorge Campos Apr 11 '18 at 01:34
  • @JorgeCampos languages are known and listed in my case. – Matas Vaitkevicius Apr 11 '18 at 03:02
  • Yeah, I noticed since unknown languages covers any listed language I thought that it would apply. But like the automatic comment states "*Possible* duplicate". Cheers :) – Jorge Campos Apr 11 '18 at 03:05

1 Answers1

1

utf8mb4

It supports all the languages you named, and practically all other languages on earth.

It's the default character set / collation in MySQL 8.0, and it's now faster than utf8.

It's the default character set in Wordpress 4.2.

Bill Karwin
  • 538,548
  • 86
  • 673
  • 828