TipLite Keep It Simple Smart

Convert all your MySQL database text fields to unicode (or any other encoding)

Have you ever faced a problem when the text fields in your database have different encoding? This usually happens when you import table structure from another database with a different encoding, or when you neglect the encoding at all, which I consider as a bad practice.
Later, this can cause some queries to fail specially if you are comparing two text fields. This may seem as a rare case but I ran into it enough times to write this post .