html显示数据库的数据类型,将HTML插入mysql数据库，显示E类型

将HTML写入数据库时常用的解决方案：

1)只需将数据库字段类型转换为blob，以便它接受二进制数据，然后将HTML编码为二进制(示例如下)。

2) 将数据库字段保留为文本字段，但base64对数据进行编码，这样数据库就不会抱怨非法字符。在# Example for case 1.

# Note that you need to make sure the database field is a blob:

html = '

Welcome!

\n

Some text

'

bin = html.encode()

dbhandle.execute('INSERT INTO script (various fields, binhtml) VALUES (..., bin)')

# When you read back the data, remember to decode.

dbhandle.execute('SELECT binhtml FROM script WHERE...')

resultset = dbhandle.fetchall()

htmlresult = resultset.decode()

# Example for case 2.

# Database field can be a text/varchar type because base64 ensures it will work.

import base64

html = '

Welcome!

\n

Some text

'

# Convert HTML into base64 encoded *text* so it can be stored in text field.

encoded = base64.b64decode(html.encode()).decode()

# Do the database INSERT.

...

# Retrieve the stored text from the database and convert back to HTML

dbhandle.execute('SELECT encodedhtml FROM script WHERE...')

resultset = dbhandle.fetchall()

htmlresult = base64.b64decode(resultset).decode()