Hi Muthu, I came to the same result. It depends where and how care2x will be used (matter of language and its sorting issues, basically).
utf_general_ci is faster - that is one of the summaries what we can read out of the documentation quite easy as first result. Well.. we can now let it as it is, when there is a client request what makes sense to change it then it is not a big headache to change it afterwards. I was just asking for the reason, nothing else :) Robert Am Montag, den 20.09.2010, 16:00 +0530 schrieb Ap.Muthu: > Hi Robert, > > http://dev.mysql.com/doc/refman/5.0/en/charset-unicode-sets.html > > Quote: > > Currently, the xxx_unicode_ci collations have only partial support for the > Unicode Collation Algorithm. Some characters are not supported yet. Also, > combining marks are not fully supported. This affects primarily Vietnamese, > Yoruba, and some smaller languages such as Navajo. > MySQL implements language-specific Unicode collations only if the ordering > with xxx_unicode_ci does not work well for a language. Language-specific > collations are UCA-based. They are derived from xxx_unicode_ci with > additional language tailoring rules. > > For any Unicode character set, operations performed using the xxx_general_ci > collation are faster than those for the xxx_unicode_ci collation. > > UnQuote > > > You are right - for now - looking forward, it appears that we will finally > have to proceed to unicode as of MySQL6 when collations wll play a good > part. Actually the collation sequences for individual fields were unicode > and all I did was to make it the default for the entire db. If there is > issues faced by Vietnamese, Yoruba and Navajo languages then we should > change. The said link is for MySQL v5.0. With the imminent release of Debian > Squeeze and other later distributions, MySQL v5.1 will be the default and > this may no longer be the issue. > > If there is consensus, then we can change the db default to > unicode_general_ci in the mysql_dump.sql. > > Regards, > Ap.Muthu > > > > > Hi Muthu, > > > > I just saw that you have switched the encoding from utf8_general_ci to > > utf8_unicode_ci. > > > > I am not sure if that is what we would like to have. Yes.. we might have > > e.g. for German language some sorting issues, but more aspects in > > Chinese and Japanese (etc) according: > > http://dev.mysql.com/doc/refman/5.0/en/charset-unicode-sets.html > > > > What do you think? > > Robert > > > > -- > > -- > > -------------------------------------------- > > CARE2X - free Integ Hospital Info System > > https://sourceforge.net/projects/care2002/ > > http://www.care2x.org > > > > > > ------------------------------------------------------------------------------ > > Start uncovering the many advantages of virtual appliances > > and start using them to simplify application deployment and > > accelerate your shift to cloud computing. > > http://p.sf.net/sfu/novell-sfdev2dev > > _______________________________________________ > > Care2002-developers mailing list > > Care2002-developers@lists.sourceforge.net > > https://lists.sourceforge.net/lists/listinfo/care2002-developers > > > > > > ------------------------------------------------------------------------------ > Start uncovering the many advantages of virtual appliances > and start using them to simplify application deployment and > accelerate your shift to cloud computing. > http://p.sf.net/sfu/novell-sfdev2dev > _______________________________________________ > Care2002-developers mailing list > Care2002-developers@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/care2002-developers -- -- -------------------------------------------- CARE2X - free Integ Hospital Info System https://sourceforge.net/projects/care2002/ http://www.care2x.org ------------------------------------------------------------------------------ Start uncovering the many advantages of virtual appliances and start using them to simplify application deployment and accelerate your shift to cloud computing. http://p.sf.net/sfu/novell-sfdev2dev _______________________________________________ Care2002-developers mailing list Care2002-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/care2002-developers
