Documentation Home
MySQL Connector/Python Developer Guide
Related Documentation Download this Manual
PDF (US Ltr) - 0.6Mb
PDF (A4) - 0.6Mb
EPUB - 136.4Kb
HTML Download (TGZ) - 85.5Kb
HTML Download (Zip) - 103.3Kb


MySQL Connector/Python Developer Guide  /  ...  /  MySQLConnection.set_charset_collation() Method

10.2.31 MySQLConnection.set_charset_collation() Method

Syntax:

cnx.set_charset_collation(charset=None, collation=None)

This method sets the character set and collation to be used for the current connection. The charset argument can be either the name of a character set, or the numerical equivalent as defined in constants.CharacterSet.

When collation is None, the default collation for the character set is used.

In the following example, we set the character set to latin1 and the collation to latin1_swedish_ci (the default collation for: latin1):


>>> cnx = mysql.connector.connect(user='scott')
>>> cnx.set_charset_collation('latin1')

Specify a given collation as follows:


>>> cnx = mysql.connector.connect(user='scott')
>>> cnx.set_charset_collation('latin1', 'latin1_general_ci')


User Comments
Sign Up Login You must be logged in to post a comment.