Jump to content

Archived

This topic is now archived and is closed to further replies.

Cantaloupe

mysql collation help needed

Recommended Posts

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/doc/refman/5.0/en/charset-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

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.