With roundup 1.4.8, Python 2.6.2, sqlite 3.6.10 and pysqlite 2.5.0 it is
not possible to create issues which contain unicode characters (like ä)
in titles or messages.

This can be reproduced with the Ubuntu Jaunty LiveCD: 
 - boot up the CD 
 - add universe and multiverse to /etc/apt/sources.list
 - apt-get install python-pysqlite2
 - download and extract roundup 1.4.8
 - run python demo.py sqlite nuke
 - try to create an issue with ä in the title -> error message

For some reason I was not able to reproduce the problem with the life CD
if the UTF-8 characters are only in the message (and not in the title).
However, on two installed Ubuntu Jaunty systems I cannot create UTF-8
messages either (all versions are the same).

Some additional information:

$ python
Python 2.6.2 (release26-maint, Apr 19 2009, 01:56:41) 
[GCC 4.3.3] on linux2
Type "help", "copyright", "credits" or "license" for more information.
>>> from roundup.backends import back_sqlite
>>> print back_sqlite.sqlite_version
2
>>>

I've re-ordered the imports which I believe will fix this issue.