[FLOW3-general] which character-set/collation setup to chose for flow3

["Christian Müller (Kitsunet)"]

On 13/11/11 21:50, Christof Adams wrote:
>
> Hi,
>
>
> mysql offers different utf8 flavours. 3 of them meet the requirements of
> multilanguage-sites.
>
> utf8_bin
>      binary, case sensitive but english or language independent sorting order
>
> utf8_general_ci
>      case insensitive but english or language independent sorting order
>
> utf8_unicode_ci
>      case insensitive and language dependent sorting order
>

Hi,

AFAIK those comments all relate to ordering of records and case 
sensitive ordering doesn't make much sense for end users in most cases. 
After all it very much depends on your usecase and those settings are 
actually only the default you can set them on a field by field basis if 
needed. I had a use case with a multilanguage site where utf8_unicode_ci 
was the best choice because of the language dependent sorting order but 
in most cases utf8_general_ci should be fine.

Cheers,
Christian