Help,A Problem of MySQL-python

[Shawn Ping]

Here are the softwares that I use
MySQL : 3.23.54
Python : 2.3.4
GCC : 3.2.2
MySQL-python-0.9.1-6.i386.rpm

when I type in "import _mysql" in a python shell,an error occurs and I have spent a lot of time handling with it but it didn't make any sense.Would anybody help me a hand ? I will be very grateful :-)
Thank you! The message is as follows:

[root@Qiuping backup]# python
Python 2.3.4 (#1, Mar 30 2006, 14:18:07)
[GCC 3.2.2 20030222 (Red Hat Linux 3.2.2-5)] on linux2
Type "help", "copyright", "credits" or "license" for more information.
>>> import _mysql
Traceback (most recent call last):
File "<stdin>", line 1, in ?
ImportError: /usr/local/lib/python2.3/site-packages/_mysql.so: undefined symbol: mysql_set_character_set