用MySQLdb，python连接mysql。

 

在sql含有中文时，提示如下错误：

 

File "/usr/local/lib/python2.4/site-packages/MySQLdb/cursors.py", line 146,
in execute

    query = query.encode(charset)

UnicodeDecodeError: 'ascii' codec can't decode byte 0xe6 in position 44:
ordinal not in range(128)

 

数据库的charset是GB2312

还请请高手赐教，如何解决？

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://python.cn/pipermail/python-chinese/attachments/20060913/851325a2/attachment.html 

´ó¼ÒºÃ
ÎҵĵçÄÔºÃÏñÖÐÁ˲¡¶¾¡£×ÜÓÐÒ»¸ö½Ð£ºspoolsv.exeµÄÏß³ÌÕ¼ÓÃcup99%£¬ÔÚÍøÉÏËÑË÷ÁËһϽâ¾ö·½·¨£¬µ«ÊÇ˵µÄÄÇЩÎļþ¼ÐÎÒµÄϵͳÀﶼûÓУ¬ÏÖÔÚ»úÆ÷·Ç³£µÄ»ºÂý£¬²»Öª´ó¼ÒË­ÓкõĽâ¾ö·½·¨£¿Ð»Ð»£¡


Qutr£¬qutianrang在gmail.com
2006-09-13 
-------------- 下一部分 --------------
Ò»¸öHTML¸½¼þ±»ÒƳý...
URL: http://python.cn/pipermail/python-chinese/attachments/20060913/8e4e2a29/attachment.html 

×^|×OvÓKb™ëb™íuçÍt÷m4§+a¢w!Šw¬yº.Ç¬–+-²œ­†‰Üžf¢–Ú)ÊØhÈbën‹§që%ŠËl§+a¢w'ÛM:÷]õçŸ)ÊØhÈbë–+-²œ­†‰Üžœ­†‰Ü†)Þ±ã2IÝm$3$-ÖéÊØhžl¬ª[*”X¥{û¬¯ùhq©–&ÿ§+a¢}¸þÈ­z–œ‘¨³ó2IÝo÷.®Ê+²œ¥Šwµã¨§{œº×ª¹êòªç«Ééܡל…ªìzÕ'‰Êx7œ¡×„®º+jÇ"‰ÊyÇž×^r‡^o+^ÓºŠzh²+b¢~8¢·b©g¢Ø§­©à{]¼r«±ëFmõÚw±¶–«¶ªæ›æ°Î¢ÎY¸€Î

ʲô°æ±¾µÄmysql?
-------------- 下一部分 --------------
Ò»¸öHTML¸½¼þ±»ÒƳý...
URL: http://python.cn/pipermail/python-chinese/attachments/20060913/70255208/attachment.html 

Ó¯uÝ­®«­‰©ëjx ™¨¥r‰¬¦Š%²÷±yË©÷Ô.¶º®¶&§­©à‚f¢•Ê&Ü TN0 ÃDD’Aˆ7q*ºØšž¶§‚	šŠW(›p€ 1Q8À
HCCÜM´Ó­=×zr¶'r§zǏ¢ËlzwiÊØhÈbë–+-²œ­†‰Ü+›±ÊâmëÛ.nÇ+‰·­¢œ­†‰Ü†)Þ±êު笶X¬¶Êr¶'ru'²æìr¸›zǧvéì¹»®&Þ¶Šr¶'r§zÇ«z«ž²Ùb²Û)ÊØhÉÃzÖ¢”‰ß¢m§ÿéÊØhÉÿ™¨¥™©ÿ–+-Šwèþœ­†‰Ü†)Þ±áÓ0µ.m§ÿéÊØhÉÿ¦*^®f¢—úr¶'r§zÇ¿jÛZržžÛ?ÛM:ÓÝwÿ¿]åÍûßö­µ§!™éí†Ù¥

确定不是中毒，在'打印机和传真'里删掉系统安装的所有打印机，重启，然后重装你的打印机。


在06-9-13，金晓峰 <unixpy at gmail.com> 写道：
>
> 用任务管理器 关闭进程，然后找到这个进程文件删除掉，即使不能清除干净，只要将它的破坏掉不能启用也可以。
>
> 在06-9-13，Qutr <qutianrang at gmail.com> 写道：
> >
> >  大家好
>
> 我的电脑好像中了病毒。总有一个叫：spoolsv.exe的线程占用cup99%，在网上搜索了一下解决方法，但是说的那些文件夹我的系统里都没有，现在机器非常的缓慢，不知大家谁有好的解决方法？谢谢！
>
>
> Qutr，qutianrang at gmail.com<%3C!--AID_FROMADDRESS_BEGIN--%3Equtianrang at gmail.com%3C!--AID_FROMADDRESS_END--%3E>
> 2006-09-13
>
> _______________________________________________
> python-chinese
> Post: send python-chinese at lists.python.cn
> Subscribe: send subscribe to python-chinese-request at lists.python.cn
> Unsubscribe: send unsubscribe to   python-chinese-request at lists.python.cn
> Detail Info: http://python.cn/mailman/listinfo/python-chinese
>
>
>
>
> _______________________________________________
> python-chinese
> Post: send python-chinese at lists.python.cn
> Subscribe: send subscribe to python-chinese-request at lists.python.cn
> Unsubscribe: send unsubscribe to  python-chinese-request at lists.python.cn
> Detail Info: http://python.cn/mailman/listinfo/python-chinese
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://python.cn/pipermail/python-chinese/attachments/20060913/0aba3d3d/attachment.html 

r‰ç3$-ÖÜ¢yÞr×[›'[ºÇ«q«\ž–¬³

r‰ç3$-ÖÜ¢yÞr×[›'[ºÇ«q«\ž–¬³

金晓峰 写道:
> 用任务管理器 关闭进程，然后找到这个进程文件删除掉，即使不能清除干净，
> 只要将它的破坏掉不能启用也可以。
>
> 在06-9-13，*Qutr* <qutianrang at gmail.com qutianrang at gmail.com>>
> 写道：
>
>     大家好
>     我的电脑好像中了病毒。总有一个叫：spoolsv.exe的线程占用cup99%，在
>     网上搜索了一下解决方法，但是说的那些文件夹我的系统里都没有，现在机
>     器非常的缓慢，不知大家谁有好的解决方法？谢谢！
>     Qutr，qutianrang at gmail.com
>     3Equtianrang at gmail.com%3C%21--AID_FROMADDRESS_END--%3E>
>     2006-09-13
>
>     _______________________________________________
>     python-chinese
>     Post: send python-chinese at lists.python.cn
>     python-chinese at lists.python.cn>
>     Subscribe: send subscribe to
>     python-chinese-request at lists.python.cn
>     python-chinese-request at lists.python.cn>
>     Unsubscribe: send unsubscribe to
>     python-chinese-request at lists.python.cn
>     python-chinese-request at lists.python.cn>
>     Detail Info: http://python.cn/mailman/listinfo/python-chinese
>
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> python-chinese
> Post: send python-chinese at lists.python.cn
> Subscribe: send subscribe to python-chinese-request at lists.python.cn
> Unsubscribe: send unsubscribe to  python-chinese-request at lists.python.cn
> Detail Info: http://python.cn/mailman/listinfo/python-chinese
是病毒么?这个spoolsv.exe似乎是打印的守护进程,你到服务里把它关闭看看!

to aTin£º°´ÕÕÄãµÄ·½·¨ÏÖÔÚ»úÆ÷Õý³£ÁË£¬Ð»Ð»¡£ÁíÍâллÆäËû¼¸Î»½â´ðµÄÅóÓÑ¡£¸ÐлlimidouÌṩµÄ°²È«ÎÀÊ¿360ɾ³ýÁËÎÒ»úÆ÷Éϼ¸¸öɾ²»µôµÄ¶«Î÷¡££º£©


Qutr£¬qutianrang在gmail.com
2006-09-14 
----- Original Message ----- 
From: aTin 
To: python-chinese 
Sent: 2006-09-13, 19:32:16
Subject: Re: [python-chinese] [Çó¾È]µçÄÔºÃÏñÖÐÁ˲¡¶¾


È·¶¨²»ÊÇÖж¾£¬ÔÚ'´òÓ¡»úºÍ´«Õæ'Àïɾµôϵͳ°²×°µÄËùÓдòÓ¡»ú£¬ÖØÆô£¬È»ºóÖØ×°ÄãµÄ´òÓ¡»ú¡£

 
ÔÚ06-9-13£¬½ðÏþ·å <unixpy在gmail.com> дµÀ£º 
ÓÃÈÎÎñ¹ÜÀíÆ÷ ¹Ø±Õ½ø³Ì£¬È»ºóÕÒµ½Õâ¸ö½ø³ÌÎļþɾ³ýµô£¬¼´Ê¹²»ÄÜÇå³ý¸É¾»£¬Ö»Òª½«ËüµÄÆÆ»µµô²»ÄÜÆôÓÃÒ²¿ÉÒÔ¡£


ÔÚ06-9-13£¬Qutr <qutianrang在gmail.com> дµÀ£º 
´ó¼ÒºÃ
ÎҵĵçÄÔºÃÏñÖÐÁ˲¡¶¾¡£×ÜÓÐÒ»¸ö½Ð£ºspoolsv.exeµÄÏß³ÌÕ¼ÓÃcup99%£¬ÔÚÍøÉÏËÑË÷ÁËһϽâ¾ö·½·¨£¬µ«ÊÇ˵µÄÄÇЩÎļþ¼ÐÎÒµÄϵͳÀﶼûÓУ¬ÏÖÔÚ»úÆ÷·Ç³£µÄ»ºÂý£¬²»Öª´ó¼ÒË­ÓкõĽâ¾ö·½·¨£¿Ð»Ð»£¡


Qutr£¬qutianrang在gmail.com
2006-09-13 


_______________________________________________
python-chinese
Post: send python-chinese在lists.python.cn 
Subscribe: send subscribe to python-chinese-request在lists.python.cn
Unsubscribe: send unsubscribe to   python-chinese-request在lists.python.cn
Detail Info: http://python.cn/mailman/listinfo/python-chinese


 

_______________________________________________
python-chinese
Post: send python-chinese在lists.python.cn
Subscribe: send subscribe to python-chinese-request在lists.python.cn 
Unsubscribe: send unsubscribe to  python-chinese-request在lists.python.cn
Detail Info: http://python.cn/mailman/listinfo/python-chinese
-------------- 下一部分 --------------
Ò»¸öHTML¸½¼þ±»ÒƳý...
URL: http://python.cn/pipermail/python-chinese/attachments/20060914/c64d3488/attachment-0001.html