Re: Vietnamese character matching with %LIKE%

[Rick James]

Here are some equivalences for some charsets/collations:

latin1 : latin1_german1_ci            B=b  C=c=Ç=ç  ch  cz       D=d      dz
latin1 : latin1_german2_ci            B=b  C=c=Ç=ç  ch  cz       D=d=Ð=ð  dz
latin1 : latin1_general_ci            B=b  C=c      ch  cz  Ç=ç  D=d      dz  Ð=ð
cp850 : cp850_general_ci              B=b  C=c      ch  cz  Ç=ç  D=d      dz  ð=Ð
utf8 : utf8_general_ci                B=b  C=c=Ç=ç  ch  cz       D=d      dz
utf8 : utf8_unicode_ci                B=b  C=c=Ç=ç  ch  cz       D=d      dz  Ð=ð
cp1250 : cp1250_general_ci            B=b  C=c=Ç=ç  ch  cz       D=d      dz

That is, I would expect `%D%` to match`Đ` in latin1_german2_ci, but not the others listed above.

For full Vietnamese collation, upgrade to 5.6:

Quote

Vietnamese collations were added for the Unicode character sets. Those based on Unicode Collation Algorithm 5.2.0 have names of the form xxx_vietnamese_520_ci (for example, utf8_vietnamese_520_ci). Those based on Unicode Collation Algorithm 4.0.0 have names of the form xxx_vietnamese_ci (for example, utf8_vietnamese_ci). These collations are the same as the corresponding xxx_unicode_520_ci and xxx_unicode_ci collations except for precomposed characters which are accented versions of “A”, “D”, “E”, “O”, and “U”.