SQLite UTF-8 inconsistency

I have a SQLite file, with certain pronunciations of words such as /ˈdɪkʃən(ə)ɹi/ in records. However, when I view it in any SQLite browser on a Mac, I see funny characters like /ÃËd开发者_如何学运维êkÃÆÃâ¢n(Ãâ¢)ùi,ÃËdêkÃÆÃâ¢nÃâºÃ¹i/, but when I use SQLite2009 Pro on a Windows, I see the characters encoded properly.

I have also placed PRAGMA encoding = "UTF-8"; but to no avail.

What is going on here?

An old question now, but the browsers you were using were broken and can't properly display UTF-8; there was nothing wrong with your input or storage. What you got back was exactly what you'd expect to see from something that doesn't support UTF-8.

Instead, use the cross-platform SQLite Manager for FireFox