Jump to content


Photo

mysql collation help needed


  • Please log in to reply
No replies to this topic

#1 Cantaloupe

Cantaloupe
  • New Members
  • Pip
  • Newbie
  • 1 posts

Posted 22 July 2006 - 11:21 PM

Hi,

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.

Thanks




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users