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

[Christof Adams]

"Christian Müller (Kitsunet)" wrote:
> 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

Hi Christian,

thanks for sharing your experience.What i'am trying to do is 

1) to assure my database setup wont introduce errors in my flow3 
setup/handling, especially in the doctrine2 part(with which i'm currently 
not quite familiar, to say the least)

2) to optimize time and reduce complexity

I know that choosing one of the three utf8_-flavours will work with flow3 
somehow. But any difference(db-server one  client connection in the other/ 
db-table in the other one) introduces time consuming conversion-steps.
Each step increases the complexity. High complexity means error hunting gets 
more demanding.Why risking this if you could avoid it by the configuration.


Cheers,
Christof