SyntaxError: (unicode error) 'unicodeescape' codec can't decode bytes in position 2-3: truncated \UX
程序员文章站
2022-06-15 13:40:49
...
今天尝试用python打开数据库文件的时候,报错
# coding:utf-8
import sqlite3
conn = sqlite3.connect("C:\Users\xcp\Desktop\sleep_data.db")
cursor = conn.cursor()
sql = """select name from sqlite_master where type='table' order by name"""
cursor.execute(sql)
result = cursor.fetchall()
print (result)
print (type(result))
conn.close()
#获得表头
错误码为
(unicode error) 'unicodeescape' codec can't decode bytes in position 2-3: truncated \UXXXXXXXX escape
即二行无法打开,尝试把"C:\Users\xcp\Desktop\sleep_data.db"print出来
print("C:\Users\xcp\Desktop\sleep_data.db")
结果为依然报错,研究了一下发现,在python中“\”是转义字符,“\u”是unicode 码
因此\user就会报错,在路径前面加个r就行了
print(r"C:\Users\xcp\Desktop\sleep_data.db")
上一篇: JavaScript 继承
下一篇: Javascript —— 继承
推荐阅读
-
SyntaxError: (unicode error) 'unicodeescape' codec can't decode bytes in position 2-3: truncated \UX
-
报错:SyntaxError: (unicode error) 'unicodeescape' codec can't decode bytes in position 2-3: truncated
-
SyntaxError: (unicode error) 'unicodeescape' codec can't decode bytes in position 2-3: truncated \UX
-
SyntaxError: (unicode error) 'unicodeescape' codec can't decode bytes in position 2-3: truncated \UX
-
SyntaxError: (unicode error) 'unicodeescape' codec can't decode bytes in position 2-3: truncated \UX
-
SyntaxError: (unicode error) 'unicodeescape' codec can't decode bytes in position 2-3: truncated \UX
-
SyntaxError: (unicode error) 'unicodeescape' codec can't decode bytes in position 2-3: truncated \UX
-
SyntaxError: (unicode error) 'unicodeescape' codec can't decode bytes in position 2-3: truncated \UX
-
SyntaxError: (unicode error) 'unicodeescape' codec can't decode bytes in position 2-3: truncated \UX
-
SyntaxError: (unicode error) 'unicodeescape' codec can't decode bytes in position 2-3: truncated \UX