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
