mysql返回值去小数_MySQL数据库返回小数('数字')值，如何转换数据类型在Python？...

标题说明了一切。调用一个MySQL数据库并获得一个数据类型，当我尝试并对其进行json化时，这种数据类型播放效果不佳。这使我疯狂地试图将这种数据类型转换为可用于前端的东西。

我试过调用float，int等等。或者Decimal类型持续存在，或者我得到一个编码错误：

UnicodeDecodeError: 'utf8' codec can't decode byte 0xf4 in position 1: invalid continuation byte编辑：

sample query result:

(('Albania', '38521', '2011'), ('Algeria', '136964', '2011'), ('Antigua and Barbuda', '206', '2011'), ('Argentina', '86351', '2011'), ('Armenia', '3251', '2011'), ('Aruba', '11511', '2011'), ('Australia', '421690', '2011'), ('Azerbaijan', '31622', '2011'),

top line of query:

original:

SELECT s.country_area AS country, SUM(s.quantity) AS quantity, m.maxyear AS maxyear

v2:

SELECT s.country_area AS country, CAST(SUM(s.quantity) AS CHAR) AS quantity, m.maxyear AS maxyearEDIT2：

v3:

SELECT s.country_area AS country, CAST(SUM(s.quantity) AS CHAR CHARACTER SET utf8) AS quantity, m.maxyear AS maxyear当我在对象上使用json.dumps时，原始获取Decimal错误

v2获取utf-8编码错误..

v2仍然会得到utf-8编码错误..