MySQL Connector/Python :: 8 Connector/Python API Reference :: 8.2 Class connection.MySQLConnection :: 8.2.29 Method MySQLConnection.set_charset_collation(charset=None, collation=None)
Section Navigation [Toggle]
- 8.2 Class connection.MySQLConnection
- 8.2.1 Constructor connection.MySQLConnection(**kwargs)
- 8.2.2 Method MySQLConnection.close()
- 8.2.3 Method MySQLConnection.config(**kwargs)
- 8.2.4 Method MySQLConnection.connect(**kwargs)
- 8.2.5 Method MySQLConnection.commit()
- 8.2.6 Method MySQLConnection.cursor(buffered=None, raw=None, cursor_class=None)
- 8.2.7 Method MySQLConnection.cmd_change_user(username='', password='', database='', charset=33)
- 8.2.8 Method MySQLConnection.cmd_debug()
- 8.2.9 Method MySQLConnection.cmd_init_db(database)
- 8.2.10 Method MySQLConnection.cmd_ping()
- 8.2.11 Method MySQLConnection.cmd_process_info()
- 8.2.12 Method MySQLConnection.cmd_process_kill(mysql_pid)
- 8.2.13 Method MySQLConnection.cmd_quit()
- 8.2.14 Method MySQLConnection.cmd_query(statement)
- 8.2.15 Method MySQLConnection.cmd_query_iter(statement)
- 8.2.16 Method MySQLConnection.cmd_refresh(options)
- 8.2.17 Method MySQLConnection.cmd_shutdown()
- 8.2.18 Method MySQLConnection.cmd_statistics()
- 8.2.19 Method MySQLConnection.disconnect()
- 8.2.20 Method MySQLConnection.get_rows(count=None)
- 8.2.21 Method MySQLConnection.get_row()
- 8.2.22 Method MySQLConnection.get_server_info()
- 8.2.23 Method MySQLConnection.get_server_version()
- 8.2.24 Method MySQLConnection.is_connected()
- 8.2.25 Method MySQLConnection.isset_client_flag(flag)
- 8.2.26 Method MySQLConnection.ping(attempts=1, delay=0)
- 8.2.27 Method MySQLConnection.reconnect(attempts=1, delay=0)
- 8.2.28 Method MySQLConnection.rollback()
- 8.2.29 Method MySQLConnection.set_charset_collation(charset=None, collation=None)
- 8.2.30 Method MySQLConnection.set_client_flags(flags)
- 8.2.31 Property MySQLConnection.autocommit
- 8.2.32 Property MySQLConnection.charset_name
- 8.2.33 Property MySQLConnection.collation_name
- 8.2.34 Property MySQLConnection.connection_id
- 8.2.35 Property MySQLConnection.database
- 8.2.36 Property MySQLConnection.get_warnings
- 8.2.37 Property MySQLConnection.raise_on_warnings
- 8.2.38 Property MySQLConnection.server_host
- 8.2.39 Property MySQLConnection.server_port
- 8.2.40 Property MySQLConnection.sql_mode
- 8.2.41 Property MySQLConnection.time_zone
- 8.2.42 Property MySQLConnection.unix_socket
- 8.2.43 Property MySQLConnection.user
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 is looked up and used.
The charset argument then be either:
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('latin1')
Specify a specific collation as follows:
>>> cnx = mysql.connector.connect(user='scott')
>>> cnx.set_charset('latin1', 'latin1_general_ci')
Copyright © 2012, Oracle and/or its affiliates. All rights
reserved.
Legal Notices
User Comments
Add your own comment.