我在学习用MySQLdb获取数据的时候,从数据库中取回的值,若用print输出,中文字符总是显示为"??",而且显示的问号个数等于中文字的个数,英文则显示正常.
<我的环境是ubuntu 6.10,mysql 5.0.22,用的unicode(基本上能选unicode的地方都用的unicode),
python2.4.>


在python中,也是使用的UTF-8编码,使用

"print '中文' "

能够正确输出中文,但是

"print 变量"(该变量由mysqldb connect.feachall()获得)

的时候出现上文所述情况,此时若用

"print type(变量)"

得到的输出是

""

若使用

变量 = unicode(变量,"编码")

则出现语法错误

然后我测试了一下文件IO,发现读取文件输出时候一切正常(中英文混合,使用print line,或者先 line =
unicode(line,"utf-8")再print line.encode("utf-8")  )

这个究竟是数据库的问题,还是mysqldb的问题,或者别的.
希望各位能够指点一下,谢谢
本人刚刚接触python,浪费大家时间了.
-------------- 下一部分 --------------
一个HTML附件被移除...
URL: http://python.cn/pipermail/python-chinese/attachments/20070412/71090354/attachment.html 

ÎÒûÓÐÊÔ¹ý¡£¿ÉÄÜÊÇÕâÑù(¿ÉÄÜ£©£º
±äÁ¿.encode('utf8')
print ±äÁ¿
-------------- 下一部分 --------------
Ò»¸öHTML¸½¼þ±»ÒƳý...
URL: http://python.cn/pipermail/python-chinese/attachments/20070412/fc1946d7/attachment.html 

这种办法也试过了,不行

在07-4-12，jessinio smith <jessinio在gmail.com> 写道：
>
> 我没有试过。可能是这样(可能）：
> 变量.encode('utf8')
> print 变量
>
> _______________________________________________
> 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/20070412/1609b52d/attachment.htm 

ÃüÁîÐд°¿Úô£¿
ºÃÏñÃüÁîÐд°¿ÚµÄ±àÂëÊÇANSI»¹ÊÇʲô
-------------- 下一部分 --------------
Ò»¸öHTML¸½¼þ±»ÒƳý...
URL: http://python.cn/pipermail/python-chinese/attachments/20070412/e9737725/attachment.html 

"好像命令行窗口的编码是ANSI还是什么"
这个我不知道
这是一个CGI程序,我在浏览器端和直接在命令行下都是一样的
在一台WIN32电脑远程用python读取mysql下输出仍然是问号
甚至保存为文件,打开仍然是问号

在07-4-12，风向标 <vaneoooo在gmail.com> 写道：
>
> 命令行窗口么？
> 好像命令行窗口的编码是ANSI还是什么
>
> _______________________________________________
> 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/20070412/9a05ad48/attachment.html 

一个HTML附件被移除...
URL: http://python.cn/pipermail/python-chinese/attachments/20070412/6f6303bb/attachment.htm 

朋友们,我碰到更搞笑的问题了,那个数据读出来不是乱码么?
我试着在数据库中插入一些中文居然成功了,而且当用mysqldb读出来之后可以正确显示.
但是在phpmyadmin中反而看起来是乱码了....
-------------- 下一部分 --------------
一个HTML附件被移除...
URL: http://python.cn/pipermail/python-chinese/attachments/20070412/6f8ca126/attachment.htm 

Ϊʲô£¿
-------------- 下一部分 --------------
Ò»¸öHTML¸½¼þ±»ÒƳý...
URL: http://python.cn/pipermail/python-chinese/attachments/20070412/62a70049/attachment.htm 

ÓÐɶºÃ¸ãЦµÄ£¬Èç¹ûÄã±íÉÏÁÐʹÓõÄÊÇliant1£¬¶øphpmyadminÓõÄÊÇgb2312£¬¾Í»áÊÇÕâÑùµÄ£¬×ÜÖ®ÊDZàÂëÎÊÌâ




SpitFire
2007-04-12



·¢¼þÈË£º ÇØ´¨
·¢ËÍʱ¼ä£º 2007-04-12 14:07:49
ÊÕ¼þÈË£º okyejr在163.com; python-chinese在lists.python.cn
³­ËÍ£º 
Ö÷Ì⣺ Re: [python-chinese]mysqldb¶Á³öÖÐÎÄ×Ö·û²»ÄÜÕý³£ÏÔʾÎÊÌâ

ÅóÓÑÃÇ,ÎÒÅöµ½¸ü¸ãЦµÄÎÊÌâÁË,ÄǸöÊý¾Ý¶Á³öÀ´²»ÊÇÂÒÂëô?
ÎÒÊÔ×ÅÔÚÊý¾Ý¿âÖвåÈëһЩÖÐÎľÓÈ»³É¹¦ÁË,¶øÇÒµ±ÓÃmysqldb¶Á³öÀ´Ö®ºó¿ÉÒÔÕýÈ·ÏÔʾ.
µ«ÊÇÔÚphpmyadminÖз´¶ø¿´ÆðÀ´ÊÇÂÒÂëÁË....
-------------- 下一部分 --------------
Ò»¸öHTML¸½¼þ±»ÒƳý...
URL: http://python.cn/pipermail/python-chinese/attachments/20070412/d4baee62/attachment.html 

不知道,但是我刚刚又有发现
在IDLE下面
>>> charset = db.character_set_name()
>>> print charset
返回的竟然是 latin1!
这个好像在以前的python-chinese也有人碰到过,据说是要用什么

set names 'utf-8'

不知道这个该如何用?


在07-4-12，jessinio smith <jessinio在gmail.com> 写道：
>
> 为什么？
-------------- 下一部分 --------------
一个HTML附件被移除...
URL: http://python.cn/pipermail/python-chinese/attachments/20070412/d54bbc4c/attachment.htm 

This is a multi-part message in MIME format.

--=====003_Dragon104603426684_=====
Content-Type: text/plain;
	charset="gb2312"
Content-Transfer-Encoding: base64

bXlzcWwgyv2+3b/ixKzIz7XEvs3Kx2xhdGluMaOsxOPSqtfUvLrJ6NbDzqp1dGYtOCy21NPa0tHT
0LXEyv2+3aOsu7nSqr340NDXqru7DQoNCg0KDQoNClNwaXRGaXJlDQoyMDA3LTA0LTEyDQoNCg0K
DQq3orz+yMujuiDH2LSoDQq3osvNyrG85KO6IDIwMDctMDQtMTIgMTQ6MjQ6NTMNCsrVvP7Iy6O6
IHB5dGhvbi1jaGluZXNlQGxpc3RzLnB5dGhvbi5jbg0Ks63LzaO6IA0K1vfM4qO6IFJlOiBbcHl0
aG9uLWNoaW5lc2VdbXlzcWxkYrbBs/bW0M7E19a3+7K7xNzV/bOjz9TKvs7KzOINCg0KsrvWqrXA
LLWrysfO0rjVuNXT1tPQt6LP1g0K1NpJRExFz8LD5g0KPj4+IGNoYXJzZXQgPSBkYi5jaGFyYWN0
ZXJfc2V0X25hbWUoKQ0KPj4+IHByaW50IGNoYXJzZXQNCre1u9i1xL65yLvKxyBsYXRpbjEhDQrV
4rj2usPP8dTa0tTHsLXEcHl0aG9uLWNoaW5lc2XSstPQyMvF9rW9uf0svt3LtcrH0qrTw8qyw7QN
Cg0KDQpzZXQgbmFtZXMgJ3V0Zi04J7K71qq1wNXiuPa4w8jnus7Twz8NCg0KDQoNCtTaMDctNC0x
MqOsamVzc2luaW8gc21pdGggPGplc3NpbmlvQGdtYWlsLmNvbT4g0LS1wKO6DQrOqsqyw7Sjvw0K

--=====003_Dragon104603426684_=====
Content-Type: text/html;
	charset="gb2312"
Content-Transfer-Encoding: base64

PCFET0NUWVBFIEhUTUwgUFVCTElDICItLy9XM0MvL0RURCBIVE1MIDQuMCBUcmFuc2l0aW9uYWwv
L0VOIj4NCjxIVE1MPjxIRUFEPg0KPE1FVEEgaHR0cC1lcXVpdj1Db250ZW50LVR5cGUgY29udGVu
dD0idGV4dC9odG1sOyBjaGFyc2V0PWdiMjMxMiI+DQo8TUVUQSBjb250ZW50PSJNU0hUTUwgNi4w
MC4yOTAwLjMwNTkiIG5hbWU9R0VORVJBVE9SPg0KPFNUWUxFPg0KPCEtLQ0KIC8qIEZvbnQgRGVm
aW5pdGlvbnMgKi8NCiBAZm9udC1mYWNlDQoJe2ZvbnQtZmFtaWx5OsvOzOU7DQoJcGFub3NlLTE6
MiAxIDYgMCAzIDEgMSAxIDEgMTt9DQpAZm9udC1mYWNlDQoJe2ZvbnQtZmFtaWx5OlZlcmRhbmE7
DQoJcGFub3NlLTE6MiAxMSA2IDQgMyA1IDQgNCAyIDQ7fQ0KQGZvbnQtZmFjZQ0KCXtmb250LWZh
bWlseToiXEDLzszlIjsNCglwYW5vc2UtMToyIDEgNiAwIDMgMSAxIDEgMSAxO30NCiAvKiBTdHls
ZSBEZWZpbml0aW9ucyAqLw0KIHAuTXNvTm9ybWFsLCBsaS5Nc29Ob3JtYWwsIGRpdi5Nc29Ob3Jt
YWwNCgl7bWFyZ2luOjBjbTsNCgltYXJnaW4tYm90dG9tOi4wMDAxcHQ7DQoJdGV4dC1hbGlnbjpq
dXN0aWZ5Ow0KCXRleHQtanVzdGlmeTppbnRlci1pZGVvZ3JhcGg7DQoJZm9udC1zaXplOjEwLjVw
dDsNCglmb250LWZhbWlseToiVGltZXMgTmV3IFJvbWFuIjt9DQphOmxpbmssIHNwYW4uTXNvSHlw
ZXJsaW5rDQoJe2NvbG9yOmJsdWU7DQoJdGV4dC1kZWNvcmF0aW9uOnVuZGVybGluZTt9DQphOnZp
c2l0ZWQsIHNwYW4uTXNvSHlwZXJsaW5rRm9sbG93ZWQNCgl7Y29sb3I6cHVycGxlOw0KCXRleHQt
ZGVjb3JhdGlvbjp1bmRlcmxpbmU7fQ0Kc3Bhbi5FbWFpbFN0eWxlMTcNCgl7bXNvLXN0eWxlLXR5
cGU6cGVyc29uYWwtY29tcG9zZTsNCglmb250LWZhbWlseTpWZXJkYW5hOw0KCWNvbG9yOndpbmRv
d3RleHQ7DQoJZm9udC13ZWlnaHQ6bm9ybWFsOw0KCWZvbnQtc3R5bGU6bm9ybWFsOw0KCXRleHQt
ZGVjb3JhdGlvbjpub25lIG5vbmU7fQ0KIC8qIFBhZ2UgRGVmaW5pdGlvbnMgKi8NCiBAcGFnZSBT
ZWN0aW9uMQ0KCXtzaXplOjU5NS4zcHQgODQxLjlwdDsNCgltYXJnaW46NzIuMHB0IDkwLjBwdCA3
Mi4wcHQgOTAuMHB0Ow0KCWxheW91dC1ncmlkOjE1LjZwdDt9DQpkaXYuU2VjdGlvbjENCgl7cGFn
ZTpTZWN0aW9uMTt9DQotLT4NCjwvU1RZTEU+DQo8L0hFQUQ+DQo8Qk9EWT4NCjxESVY+PEZPTlQg
ZmFjZT1WZXJkYW5hIGNvbG9yPSMwMDAwZmYgc2l6ZT0yPm15c3FsIA0Kyv2+3b/ixKzIz7XEvs3K
x2xhdGluMaOsxOPSqtfUvLrJ6NbDzqp1dGYtOCy21NPa0tHT0LXEyv2+3aOsu7nSqr340NDXqru7
PC9GT05UPjwvRElWPg0KPERJVj48Rk9OVCBmYWNlPVZlcmRhbmEgc2l6ZT0yPjwvRk9OVD4mbmJz
cDs8L0RJVj4NCjxESVYgYWxpZ249bGVmdD4NCjxESVYgYWxpZ249bGVmdD48Rk9OVCBmYWNlPVZl
cmRhbmEgc2l6ZT0yPg0KPEhSIHN0eWxlPSJXSURUSDogMTIycHg7IEhFSUdIVDogMnB4IiBTSVpF
PTI+DQo8L0ZPTlQ+PC9ESVY+DQo8RElWPjxGT05UIGNvbG9yPSNjMGMwYzA+PEZPTlQgZmFjZT1W
ZXJkYW5hIHNpemU9Mj5TcGl0RmlyZTwvRk9OVD48L0RJVj4NCjxESVY+PEZPTlQgZmFjZT1WZXJk
YW5hIHNpemU9Mj4yMDA3LTA0LTEyPC9GT05UPjwvRk9OVD48L0RJVj48L0RJVj4NCjxESVY+PEZP
TlQgZmFjZT1WZXJkYW5hIHNpemU9Mj4NCjxIUj4NCjwvRk9OVD48L0RJVj4NCjxESVY+PEZPTlQg
ZmFjZT1WZXJkYW5hPjxGT05UIHNpemU9Mj48U1RST05HPreivP7Iy6O6PC9TVFJPTkc+IA0Kx9i0
qDwvRk9OVD48L0ZPTlQ+PC9ESVY+DQo8RElWPjxGT05UIGZhY2U9VmVyZGFuYT48Rk9OVCBzaXpl
PTI+PFNUUk9ORz63osvNyrG85KO6PC9TVFJPTkc+IA0KMjAwNy0wNC0xMiZuYnNwOzE0OjI0OjUz
PC9GT05UPjwvRk9OVD48L0RJVj4NCjxESVY+PEZPTlQgZmFjZT1WZXJkYW5hPjxGT05UIHNpemU9
Mj48U1RST05HPsrVvP7Iy6O6PC9TVFJPTkc+IA0KcHl0aG9uLWNoaW5lc2VAbGlzdHMucHl0aG9u
LmNuPC9GT05UPjwvRk9OVD48L0RJVj4NCjxESVY+PEZPTlQgZmFjZT1WZXJkYW5hPjxGT05UIHNp
emU9Mj48U1RST05HPrOty82jujwvU1RST05HPiA8L0ZPTlQ+PC9GT05UPjwvRElWPg0KPERJVj48
Rk9OVCBmYWNlPVZlcmRhbmE+PEZPTlQgc2l6ZT0yPjxTVFJPTkc+1vfM4qO6PC9TVFJPTkc+IFJl
OiANCltweXRob24tY2hpbmVzZV1teXNxbGRitsGz9tbQzsTX1rf7srvE3NX9s6PP1Mq+zsrM4jwv
Rk9OVD48L0ZPTlQ+PC9ESVY+DQo8RElWPjxGT05UIGZhY2U9VmVyZGFuYSBzaXplPTI+PC9GT05U
PiZuYnNwOzwvRElWPg0KPERJVj48Rk9OVCBmYWNlPVZlcmRhbmEgc2l6ZT0yPrK71qq1wCy1q8rH
ztK41bjV09bT0Leiz9Y8QlI+1NpJRExFz8LD5jxCUj4mZ3Q7Jmd0OyZndDsgY2hhcnNldCANCj0g
ZGIuY2hhcmFjdGVyX3NldF9uYW1lKCk8QlI+Jmd0OyZndDsmZ3Q7IHByaW50IGNoYXJzZXQ8QlI+
t7W72LXEvrnIu8rHIA0KbGF0aW4xITxCUj7V4rj2usPP8dTa0tTHsLXEcHl0aG9uLWNoaW5lc2XS
stPQyMvF9rW9uf0svt3LtcrH0qrTw8qyw7Q8QlI+PEJSPjxQUkU+c2V0IG5hbWVzICd1dGYtOCc8
QlI+PEJSPrK71qq1wNXiuPa4w8jnus7Twz88QlI+DQo8L1BSRT48QlI+DQo8RElWPjxTUEFOIGNs
YXNzPWdtYWlsX3F1b3RlPtTaMDctNC0xMqOsPEIgY2xhc3M9Z21haWxfc2VuZGVybmFtZT5qZXNz
aW5pbyANCnNtaXRoPC9CPiAmbHQ7PEEgaHJlZj0ibWFpbHRvOmplc3NpbmlvQGdtYWlsLmNvbSI+
amVzc2luaW9AZ21haWwuY29tPC9BPiZndDsgDQrQtLXAo7o8L1NQQU4+DQo8QkxPQ0tRVU9URSBj
bGFzcz1nbWFpbF9xdW90ZSANCnN0eWxlPSJQQURESU5HLUxFRlQ6IDFleDsgTUFSR0lOOiAwcHQg
MHB0IDBwdCAwLjhleDsgQk9SREVSLUxFRlQ6IHJnYigyMDQsMjA0LDIwNCkgMXB4IHNvbGlkIj7O
qsqyw7SjvzwvQkxPQ0tRVU9URT48L0RJVj48L0ZPTlQ+PC9ESVY+PC9CT0RZPjwvSFRNTD4NCg==

--=====003_Dragon104603426684_=====--

谢谢大家,现在它可以正常工作了,原来我需要在执行之前先执行一个
c.execute("SET NAMES 'utf8'")
这样mysqldb就可以进行中文读取了.

在07-4-12，SpitFire <spitfire2在gmail.com> 写道：
>
>  有啥好搞笑的，如果你表上列使用的是liant1，而phpmyadmin用的是gb2312，就会是这样的，总之是编码问题
>
>  ------------------------------
>  SpitFire
> 2007-04-12
>  ------------------------------
>  *发件人：* 秦川
> *发送时间：* 2007-04-12 14:07:49
> *收件人：* okyejr在163.com; python-chinese在lists.python.cn
> *抄送：*
> *主题：* Re: [python-chinese]mysqldb读出中文字符不能正常显示问题
>
> 朋友们,我碰到更搞笑的问题了,那个数据读出来不是乱码么?
> 我试着在数据库中插入一些中文居然成功了,而且当用mysqldb读出来之后可以正确显示.
> 但是在phpmyadmin中反而看起来是乱码了....
>
> _______________________________________________
> 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/20070412/dfc835aa/attachment.htm 

ÓÖѧ»áÒ»ÕÐÁË£¡ÄãµÄŬÁ¦Ê¹ÎÒÉÙ»¨ºÜ¶àʱ¼ä
-------------- 下一部分 --------------
Ò»¸öHTML¸½¼þ±»ÒƳý...
URL: http://python.cn/pipermail/python-chinese/attachments/20070412/7da4f7b0/attachment.html 

我用adodb类库

在 07-4-12，jessinio smith<jessinio在gmail.com> 写道：
> 又学会一招了！你的努力使我少花很多时间
>
> _______________________________________________
> 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
>

haha,¾ÍÊÇÕâÑù
Èç¹ûÄã·µ»ØµÄÍøÒ³±àÂëÊÇgb2312µÄ£¬Äã¾ÍÐèҪд set names 'gbk' ÁË

On 4/12/07, ÇØ´¨ <anewrer在gmail.com> wrote:
>
> лл´ó¼Ò,ÏÖÔÚËü¿ÉÒÔÕý³£¹¤×÷ÁË,Ô­À´ÎÒÐèÒªÔÚÖ´ÐÐ֮ǰÏÈÖ´ÐÐÒ»¸ö
> c.execute("SET NAMES 'utf8'")
> ÕâÑùmysqldb¾Í¿ÉÒÔ½øÐÐÖÐÎĶÁÈ¡ÁË.
>
> ÔÚ07-4-12£¬SpitFire <spitfire2在gmail.com> дµÀ£º
> >
> >  ÓÐɶºÃ¸ãЦµÄ£¬Èç¹ûÄã±íÉÏÁÐʹÓõÄÊÇliant1£¬¶øphpmyadminÓõÄÊÇgb2312£¬¾Í»áÊÇÕâÑùµÄ£¬×ÜÖ®ÊDZàÂëÎÊÌâ
> >
> >  ------------------------------
> >  SpitFire
> > 2007-04-12
> >  ------------------------------
> >  *·¢¼þÈË£º* ÇØ´¨
> > *·¢ËÍʱ¼ä£º* 2007-04-12 14:07:49
> > *ÊÕ¼þÈË£º* okyejr在163.com; python-chinese在lists.python.cn
> > *³­ËÍ£º*
> > *Ö÷Ì⣺* Re: [python-chinese]mysqldb¶Á³öÖÐÎÄ×Ö·û²»ÄÜÕý³£ÏÔʾÎÊÌâ
> >
> > ÅóÓÑÃÇ,ÎÒÅöµ½¸ü¸ãЦµÄÎÊÌâÁË,ÄǸöÊý¾Ý¶Á³öÀ´²»ÊÇÂÒÂëô?
> > ÎÒÊÔ×ÅÔÚÊý¾Ý¿âÖвåÈëһЩÖÐÎľÓÈ»³É¹¦ÁË,¶øÇÒµ±ÓÃmysqldb¶Á³öÀ´Ö®ºó¿ÉÒÔÕýÈ·ÏÔʾ.
> > µ«ÊÇÔÚphpmyadminÖз´¶ø¿´ÆðÀ´ÊÇÂÒÂëÁË....
> >
> > _______________________________________________
> > 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
>



-- 
Guo Jinpeng
Mobile:86-13811168737
Room430,Building 45 jia,Peking University
BeiJing 100871
-------------- 下一部分 --------------
Ò»¸öHTML¸½¼þ±»ÒƳý...
URL: http://python.cn/pipermail/python-chinese/attachments/20070412/c1433816/attachment.htm 

你是用
phpMyAdmin么？把phpMyAdmin的字符集调整成utf8,把你数据库也调整成utf-8，然后在mysqldb里面执行sql查询前，执行一句
SET NAMES utf8;

在07-4-12，mmx <mmxpeng at gmail.com> 写道：
>
>
> haha,就是这样
> 如果你返回的网页编码是gb2312的，你就需要写 set names 'gbk' 了
>
> On 4/12/07, 秦川 <anewrer at gmail.com> wrote:
>
> > 谢谢大家,现在它可以正常工作了,原来我需要在执行之前先执行一个
> > c.execute("SET NAMES 'utf8'")
> > 这样mysqldb就可以进行中文读取了.
> >
> > 在07-4-12，SpitFire <spitfire2 at gmail.com> 写道：
> > >
> > >  有啥好搞笑的，如果你表上列使用的是liant1，而phpmyadmin用的是gb2312，就会是这样的，总之是编码问题
> > >
> > >  ------------------------------
> > >  SpitFire
> > > 2007-04-12
> > >  ------------------------------
> > >  *发件人：* 秦川
> > > *发送时间：* 2007-04-12 14:07:49
> > > *收件人：* okyejr at 163.com; python-chinese at lists.python.cn
> > > *抄送：*
> > > *主题：* Re: [python-chinese]mysqldb读出中文字符不能正常显示问题
> > >
> > > 朋友们,我碰到更搞笑的问题了,那个数据读出来不是乱码么?
> > > 我试着在数据库中插入一些中文居然成功了,而且当用mysqldb读出来之后可以正确显示.
> > > 但是在phpmyadmin中反而看起来是乱码了....
> > >
> > > _______________________________________________
> > > 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
> >
>
>
>
> --
> Guo Jinpeng
> Mobile:86-13811168737
> Room430,Building 45 jia,Peking University
> BeiJing 100871
> _______________________________________________
> 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
>



-- 
武长斌
chbin.w at gmail.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://python.cn/pipermail/python-chinese/attachments/20070412/6645579f/attachment.html 

恩，是的。
我的phpmyadmin可以正常执行

在07-4-12，武长斌 <chbin.w在gmail.com> 写道：
>
> 你是用
> phpMyAdmin么？把phpMyAdmin的字符集调整成utf8,把你数据库也调整成utf-8，然后在mysqldb里面执行sql查询前，执行一句
> SET NAMES utf8;
>
> 在07-4-12，mmx <mmxpeng在gmail.com > 写道：
> >
> >
> > haha,就是这样
> > 如果你返回的网页编码是gb2312的，你就需要写 set names 'gbk' 了
> >
> > On 4/12/07, 秦川 < anewrer在gmail.com> wrote:
> >
> > > 谢谢大家,现在它可以正常工作了,原来我需要在执行之前先执行一个
> > > c.execute("SET NAMES 'utf8'")
> > > 这样mysqldb就可以进行中文读取了.
> > >
> > > 在07-4-12，SpitFire <spitfire2在gmail.com> 写道：
> > > >
> > > >  有啥好搞笑的，如果你表上列使用的是liant1，而phpmyadmin用的是gb2312，就会是这样的，总之是编码问题
> > > >
> > > >  ------------------------------
> > > >  SpitFire
> > > > 2007-04-12
> > > >  ------------------------------
> > > >  *发件人：* 秦川
> > > > *发送时间：* 2007-04-12 14:07:49
> > > > *收件人：* okyejr在163.com; python-chinese在lists.python.cn
> > > > *抄送：*
> > > > *主题：* Re: [python-chinese]mysqldb读出中文字符不能正常显示问题
> > > >
> > > > 朋友们,我碰到更搞笑的问题了,那个数据读出来不是乱码么?
> > > > 我试着在数据库中插入一些中文居然成功了,而且当用mysqldb读出来之后可以正确显示.
> > > > 但是在phpmyadmin中反而看起来是乱码了....
> > > >
> > > > _______________________________________________
> > > > 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
> > >
> >
> >
> >
> > --
> > Guo Jinpeng
> > Mobile:86-13811168737
> > Room430,Building 45 jia,Peking University
> > BeiJing 100871
> > _______________________________________________
> > 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
> >
>
>
>
> --
> 武长斌
> chbin.w在gmail.com
> _______________________________________________
> 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/20070412/2be405f0/attachment-0001.htm 

在你的mysqladmin能够正常显示汉字的时候，看看你的浏览器的字符集是什么,

在07-4-12，秦川 <anewrer at gmail.com> 写道：
>
> 恩，是的。
> 我的phpmyadmin可以正常执行
>
> 在07-4-12，武长斌 <chbin.w at gmail.com> 写道：
> >
> > 你是用
> > phpMyAdmin么？把phpMyAdmin的字符集调整成utf8,把你数据库也调整成utf-8，然后在mysqldb里面执行sql查询前，执行一句
> > SET NAMES utf8;
> >
> > 在07-4-12，mmx < mmxpeng at gmail.com > 写道：
> > >
> > >
> > > haha,就是这样
> > > 如果你返回的网页编码是gb2312的，你就需要写 set names 'gbk' 了
> > >
> > > On 4/12/07, 秦川 < anewrer at gmail.com> wrote:
> > >
> > > > 谢谢大家,现在它可以正常工作了,原来我需要在执行之前先执行一个
> > > > c.execute("SET NAMES 'utf8'")
> > > > 这样mysqldb就可以进行中文读取了.
> > > >
> > > > 在07-4-12，SpitFire <spitfire2 at gmail.com> 写道：
> > > > >
> > > > >  有啥好搞笑的，如果你表上列使用的是liant1，而phpmyadmin用的是gb2312，就会是这样的，总之是编码问题
> > > > >
> > > > >  ------------------------------
> > > > >  SpitFire
> > > > > 2007-04-12
> > > > >  ------------------------------
> > > > >  *发件人：* 秦川
> > > > > *发送时间：* 2007-04-12 14:07:49
> > > > > *收件人：* okyejr at 163.com; python-chinese at lists.python.cn
> > > > > *抄送：*
> > > > > *主题：* Re: [python-chinese]mysqldb读出中文字符不能正常显示问题
> > > > >
> > > > > 朋友们,我碰到更搞笑的问题了,那个数据读出来不是乱码么?
> > > > > 我试着在数据库中插入一些中文居然成功了,而且当用mysqldb读出来之后可以正确显示.
> > > > > 但是在phpmyadmin中反而看起来是乱码了....
> > > > >
> > > > > _______________________________________________
> > > > > 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
> > > >
> > >
> > >
> > >
> > > --
> > > Guo Jinpeng
> > > Mobile:86-13811168737
> > > Room430,Building 45 jia,Peking University
> > > BeiJing 100871
> > > _______________________________________________
> > > 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
> > >
> >
> >
> >
> > --
> > 武长斌
> > chbin.w at gmail.com
> > _______________________________________________
> > 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
>



-- 
武长斌
chbin.w at gmail.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://python.cn/pipermail/python-chinese/attachments/20070412/aa1f6a28/attachment.htm 

conn = MySQLdb.connect(host="192.168.1.168",db="ewyu",user="root",
              passwd="catcat",use_unicode=1, charset='utf8')

insert data:
cursor.execute( query.decode("gbk").encode("utf-8") )



在 07-4-12，武长斌<chbin.w at gmail.com> 写道：
> 在你的mysqladmin能够正常显示汉字的时候，看看你的浏览器的字符集是什么,
>
> 在07-4-12，秦川 <anewrer at gmail.com> 写道：
> > 恩，是的。
> > 我的phpmyadmin可以正常执行
> >
> >
> > 在07-4-12，武长斌 < chbin.w at gmail.com> 写道：
> > >
> > > 你是用
> phpMyAdmin么？把phpMyAdmin的字符集调整成utf8,把你数据库也调整成utf-8，然后在mysqldb里面执行sql查询前，执行一句
>  SET NAMES utf8;
> > >
> > >
> > > 在07-4-12，mmx < mmxpeng at gmail.com > 写道：
> > > >
> > > >
> > > >
> > > > haha,就是这样
> > > > 如果你返回的网页编码是gb2312的，你就需要写 set names 'gbk' 了
> > > >
> > > >
> > > > On 4/12/07, 秦川 < anewrer at gmail.com> wrote:
> > > > >
> > > > >
> > > > > 谢谢大家,现在它可以正常工作了,原来我需要在执行之前先执行一个
> > > > > c.execute("SET NAMES 'utf8'")
> > > > > 这样mysqldb就可以进行中文读取了.
> > > > >
> > > > > 在07-4-12，SpitFire <spitfire2 at gmail.com> 写道：
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> 有啥好搞笑的，如果你表上列使用的是liant1，而phpmyadmin用的是gb2312，就会是这样的，总之是编码问题
> > > > > >
> > > > > >
> > > > > > ________________________________
>
> > > > > > SpitFire
> > > > > > 2007-04-12
> > > > > > ________________________________
>
> > > > > > 发件人： 秦川
> > > > > > 发送时间： 2007-04-12 14:07:49
> > > > > > 收件人： okyejr at 163.com; python-chinese at lists.python.cn
> > > > > > 抄送：
> > > > > > 主题： Re: [python-chinese]mysqldb读出中文字符不能正常显示问题
> > > > > >
> > > > > > 朋友们,我碰到更搞笑的问题了,那个数据读出来不是乱码么?
> > > > > > 我试着在数据库中插入一些中文居然成功了,而且当用mysqldb读出来之后可以正确显示.
> > > > > > 但是在phpmyadmin中反而看起来是乱码了....
> > > > > >
> > > > > > _______________________________________________
> > > > > > 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
> > > > >
> > > >
> > > >
> > > >
> > > > --
> > > > Guo Jinpeng
> > > > Mobile:86-13811168737
> > > > Room430,Building 45 jia,Peking University
> > > > BeiJing 100871
> > > > _______________________________________________
> > > > 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
> > > >
> > >
> > >
> > >
> > > --
> > > 武长斌
> > > chbin.w at gmail.com
> > > _______________________________________________
> > > 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
> >
>
>
>
> --
> 武长斌
> chbin.w at gmail.com
> _______________________________________________
> 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
>


-- 
花开邑大，漫步心月湖。
http://www.ewyu.com/