MySQL Connector/Python Developer Guide

10.2.39 MySQLConnection.collation Property

This property returns a string indicating which collation is used for the connection, whether or not it is connected.