import mariadb

conn=mariadb.connect(db="test")

cursor=conn.cursor()

cursor.execute("create temporary table t1(a json)")

cursor.execute("insert into t1 values ('{}')")

cursor.execute("select * from t1");

fieldinfo= mariadb.fieldinfo()

info= cursor.description

print(fieldinfo.type(info[0]))

del cursor

del connection

BLOB