我正在python 2.7版本中运行此代码。
import sys, os
sys.path.append(os.path.join(os.path.split(os.path.abspath(__file__))[0], 'lib'))
from bottle import route, run, static_file, request
import pymysql as db
import settings
con = db.connect(
settings.mysql_host,
settings.mysql_user,
settings.mysql_passwd,
settings.mysql_schema,
charset='utf8',
use_unicode=True)
cur = con.cursor()
cur.execute("SELECT tragoudi.titlos, tragoudi.etos_par, cd_production.etaireia FROM tragoudi JOIN singer_prod ON tragoudi.titlos=singer_prod.title JOIN cd_production ON singer_prod.cd=cd_production.code_cd GROUP BY tragoudi.titlos HAVING tragoudi.titlos LIKE %s AND tragoudi.etos_par LIKE %s AND cd_production.etaireia LIKE %s",("ΑΓΩΝΙΑ","1978","SONY"))
con.commit()
#cur.execute("SELECT * FROM kalitexnis")
for row in cur.fetchall():
table = row[:]
print table
con.close()
结果我得到了:
^{pr2}$这是正确的,因为单词'unicode'sallusofthecompany'is^{cd1>}^{cd2>}等。 所以我的问题是如果有一种方法,当我^{cd3>}得到结果
^{pr3}$
python2使用u作为前缀,告诉它它是一个Unicode字符串,因此,如果逐个元素打印列表元素,它应该可以正确地打印出来。在
所以:
相关问题 更多 >
编程相关推荐