I'll just leave this here:

http://wiki.postgresql.org/wiki/Things_to_find_out_about_whe...

Plus, I've heard that mysql will ignore maxlength for chars, causing issues when moving those to postgres.