Hi frals thank you for developing such a good application:-) I'd like to report a issue with decoding headers including Japanese.

fmms can't downlad msg when From header contains Japanese characters encoded with utf8.

/tmp/fmms.log is af following...

----

2010-05-26 02:50:01,349 fmms.__main__: Failed to open viewer with transaction id: BBAAAG5Rc7WgmEB0lXt6yAhXAEgbAAAAAAAAAAAA
Traceback (most recent call last):
File "/opt/fmms/fmms_gui.py", line 415, in show_mms
fMMSViewer.fMMS_Viewer(transactionid, spawner=self)
File "/opt/fmms/fmms_viewer.py", line 53, in __init__
self._parse_mms(fname, vbox)
File "/opt/fmms/fmms_viewer.py", line 213, in _parse_mms
headerlist = self.cont.get_mms_headers(filename)
File "/opt/fmms/controller.py", line 252, in get_mms_headers
return self.store.get_mms_headers(transactionid)
File "/opt/fmms/dbhandler.py", line 395, in get_mms_headers
for line in c:
OperationalError: Could not decode to UTF-8 column 'value' with text '��8�Takahiro xxx <sleepy_ragedy_ann@xxx.jp>'
---

I investigate its root cause, I guess it is an issue of pysqlite decoding utf8.

I can download mms msg correctly by changing dbhandler.py as following.

---
(orig)
self.conn.text_factory = sqlite3.OptimizedUnicode
(fixed)
self.conn.text_factory = str
----

Could you consider merging this fix?

regards.

kenya888