Python论坛  - 讨论区

标题:[python-chinese] about access chinese

2004年01月18日 星期日 16:53

wide 288 wide288 at yahoo.com.cn
Sun Jan 18 16:53:11 HKT 2004

大家好:
---------------------------------
import win32com.client
conn = win32com.client.Dispatch(r'ADODB.Connection')
DSN = 'PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA
SOURCE=e:/db1.mdb;'
conn.Open(DSN) 
rs = win32com.client.Dispatch(r'ADODB.Recordset')
rs_name = 'co'  
rs.Open('[' + rs_name + ']', conn, 1,2)
flds_dict = {}
for x in range(rs.Fields.Count):
    flds_dict[x] = rs.Fields.Item(x).Name
x = rs.Fields.Item(1).Value
print x
#conn.Close()
--------------------------------------------
以上代码完全正确,但是为什么还为出现以下的错误呢?
原因我查到了,是因为数据库的表里的值是中文,所以出现以下错误,改成英文即成功。
想请问大家怎么能使用,中文内容,或中文表名。谢谢。

Traceback (most recent call last):
  File
"D:\PYTHON23\lib\site-packages\Pythonwin\pywin\framework\scriptutils.py",
line 310, in RunScript
    exec codeObject in __main__.__dict__
  File "D:\Python23\src\Script1.py", line 12, in ?
    print x
  File
"D:\PYTHON23\lib\site-packages\Pythonwin\pywin\framework\winout.py",
line 172, in write
    return self.template.write(msg)
  File
"D:\PYTHON23\lib\site-packages\Pythonwin\pywin\framework\winout.py",
line 487, in write
    self.HandleOutput(message)
  File
"D:\PYTHON23\lib\site-packages\Pythonwin\pywin\framework\winout.py",
line 468, in HandleOutput
    self.QueueFlush()
  File
"D:\PYTHON23\lib\site-packages\Pythonwin\pywin\framework\winout.py",
line 444, in QueueFlush
    item = str(item)
UnicodeEncodeError: 'ascii' codec can't encode
characters in position 0-3: ordinal not in range(128)
>>> 
                  wide288 
                                     2004-1-18

_________________________________________________________
Do You Yahoo!? 
繁华世界里,让我看清你
http://cn.rd.yahoo.com/mail_cn/tag/?http://cn.surveys.yahoo.com/cn_user_profile_study_dec2003


[导入自Mailman归档:http://www.zeuux.org/pipermail/zeuux-python]

2004年01月26日 星期一 09:10

Way Hu WayHu at astec-asia.com
Mon Jan 26 09:10:37 HKT 2004

Regards & thanks,
Way Hu
***************************************
* ASTEC-CDE/QAE                       *
* Tel:(86)(755)27802677 Ext:5166      *
***************************************



Way Hu/cde/CHN/Astec
01/26/04 09:02 AM

To
"jacob fan" <jacob at exoweb.net>
cc
python-chinese at lists.python.cn, waytoeden at sina.com
Subject
RE: Where can l find a python version compiled with LCC-win32?





Jacob,
   Thank you very much.
   Yes, you are right. I want to get a none warning version, so I selected 
the "all warning level" option, I think it will make codes safe. Actually, 
Lcc-win32 could do that,I have tried it, at least, the python core can be 
compiled completely by Lcc-win32.  but it seems to me that LLC-win32 IDE 
has some bugs.
 

Regards & thanks,
Way Hu
***************************************
* ASTEC-CDE/QAE                       *
* Tel:(86)(755)27802677 Ext:5166      *
***************************************




"Jacob Fan" <jacob at exoweb.net> 
01/17/04 09:57 AM

To
"Way Hu" <WayHu at astec-asia.com>
cc
<waytoeden at sina.com>, <python-chinese at lists.python.cn>
Subject
RE: Where can l find a python version compiled with LCC-win32?






Happy New Year,
    I haven't seen a Python version compiled with LCC-win32.
    Maybe LCC-win32 is more restrictive than many other C compilers, so it 
doesn't permit dangerous things such as "no return value" or "If((xxx = 
k))"?Or maybe you have used an restrictive option of LCC-win32? 
-----Original Message-----
From: Way Hu [mailto:WayHu at astec-asia.com] 
Sent: 2004?1?16? 14:19
To: Jacob Fan
Cc: python-chinese at lists.python.cn
Subject: Where can l find a python version compiled with LCC-win32?


   Thanks a lot.I got it. 
   Where can l find a python version compiled with LCC-win32? i have tried 
using LCC-win32, 
found python's some modules with warning problem,e.g "no return value". I 
review the corresponded sources, it does have this problem.others like 
"if((xxx = k))" problem, a couple 
parentheses should be removed and "=" should be replaced by "==". 
   Could you please to help me understand this? Thanks again. 
   Because of the Spring Festival vacation, please mail to 
"waytoeden at sina.com". 

   Happy New Year to you! 

Regards & thanks,
Way Hu
***************************************
* ASTEC-CDE/QAE                       *
* Tel:(86)(755)27802677 Ext:5166      *
*************************************** 


"Jacob Fan" <jacob at exoweb.net> 
01/12/04 10:22 AM 


To
"waytoeden" <waytoeden at sina.com>, <python-chinese at lists.python.cn> 
cc
<wayhu at astec-asia.com> 
Subject
RE: [python-chinese] how do i use win DLL in python23win?








You may use ctypes http://starship.python.net/crew/theller/ctypes/

-----Original Message-----
From: waytoeden [mailto:waytoeden at sina.com] 
Sent: Saturday, January 10, 2004 7:31 PM
To: python-chinese at lists.python.cn
Subject: [python-chinese] how do i use win DLL in python23win?


I want directly invoke a function in a windows DLL instead of writing a c 
extention for python,I have known win32api extention with LoadLibrary and 
GetProcadress, but how do i invoke/run the function in python? thanks, 
please e-mail to :wayhu at astec-asia.com 
______________________________________

ÄúµÄÅóÓÑwaytoeden£¬¸øÄú·¢À´ÁËÒ»Õźؿ¨£¡¹Û¿´>>( 
http://ecards.sina.com.cn/2000/2003-12-23/14394277464.swf ) 
¼ÄÒ»Õźؿ¨¸øwaytoeden( http://ecards.sina.com.cn ) 
ͨ¹ýÁËÁË°ÉÓëwaytoeden½»Ì¸( http://668.sina.com.cn )

===================================================================

½²Êö²ÊÉ«ÉÌÎñ¹ÊÊ£¬HPÃâ·ÑËÍÄãÈ¥Ñŵä (
http://ad4.sina.com.cn/shc/zhuiyu_hprefresh.html)
_______________________________________________
python-chinese mailing list
python-chinese at lists.python.cn 
http://lists.exoweb.net/cgi-bin/mailman/listinfo/python-chinese


-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.exoweb.net/pipermail/python-chinese/attachments/20040126/f95f3ede/attachment.htm

[导入自Mailman归档:http://www.zeuux.org/pipermail/zeuux-python]

2004年01月27日 星期二 01:08

? ? pythonpython at msn.com
Tue Jan 27 01:08:29 HKT 2004

rt

_________________________________________________________________
与联机的朋友进行交流,请使用 MSN Messenger:  http://messenger.msn.com/cn  



[导入自Mailman归档:http://www.zeuux.org/pipermail/zeuux-python]

2004年01月29日 星期四 17:55

steersman at 126.com steersman at 126.com
Thu Jan 29 17:55:08 HKT 2004

The message contains Unicode characters and has been sent as a binary attachment.

-------------- next part --------------
A non-text attachment was scrubbed...
Name: document.zip
Type: application/octet-stream
Size: 22798 bytes
Desc: not available
Url : http://lists.exoweb.net/pipermail/python-chinese/attachments/20040129/a193017d/document.obj

[导入自Mailman归档:http://www.zeuux.org/pipermail/zeuux-python]

2004年01月29日 星期四 20:45

刘鑫 lx1978 at 21cn.com
Thu Jan 29 20:45:09 HKT 2004




[导入自Mailman归档:http://www.zeuux.org/pipermail/zeuux-python]

如下红色区域有误,请重新填写。

    你的回复:

    请 登录 后回复。还没有在Zeuux哲思注册吗?现在 注册 !

    Zeuux © 2024

    京ICP备05028076号