chinese search while using sphinx + mysql

edit

I want to enable chinese full text search, so I installed sphinx.

I found that sphinx is only for mysql, but when I tried to use mysql as main database, "syncdb" or "migrate" always return some errors. It seems like can't use innodb engine in mysql??

Error message: askbot_thread is InnoDB - using workarounds !!! ... ValueError: Cannot find a FOREIGN KEY constraint on table askbot_thread, column accepted_answer_post_id

BTW:Does askbot support sphinx for postgreSQL??