C
cverbiest
Guest
After migration to utf-8 our customer noted that the item table is sorted differently. We need utf-8 because we have to be able to store different languages but we'd like to have the same sorting as in iso8859-1. I know this is done by specifying the collation but I can't find documentation explaining which collection table is what. e.g. I expected ICU-be.df to be for Belgium but then I noticed ICU_48-be.df is for Belarus, I suspect ICU-be.df is for Belarus as well. Mutlple questions Is there an overview table explaining the different collations and there uses ? What is the difference between the 48 collation tables and the others ? which are the more up-to-date versions ? Is there a table that matches iso8859 or table that would sort [] (square brackets) in the same position as iso8859-1 ? /* iso-8859-1 sorting */ EBRUBARROMA HT60 EBRUBARROMA HT65 EBRUBARROMA HT80 EBRUBARROMA [HT] /* utf-8 sorting */ EBRUBARROMA [HT] EBRUBARROMA HT60 EBRUBARROMA HT65 EBRUBARROMA HT80
Continue reading...
Continue reading...