I need help understanding the way mysql collations are supposed to work. I use latin1_german2_ci for all settings (connection, collation, etc). This page (http://dev.mysql.com...et-we-sets.html) says that latin1_german2_ci translates between German umlauts and their counterparts. (ü=ue, ä=ae, ö=oe). The part I don't understand is, if this will only work for sorting results or if mysql is supposed to return strings that contain "ae" if I run a search on "ä" too. Im not sure if I'm doing something wrong or if collations are only important for sorting results.
Any help appreciated.
mysql collation help needed
No replies to this topic
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users