Setting character set at connection fails

[Geert JM Vanderkelen]

The charset connection option is ignored

    db = mysql.connect(user='root',buffered=True,
        charset="latin7")
    cur = db.cursor()

    cur.execute("SHOW VARIABLES LIKE '%%char%%'")
    print_rows(cur.fetchall())

outputs

(u'character_set_client', u'utf8')
(u'character_set_connection', u'utf8')
(u'character_set_database', u'utf8')
(u'character_set_filesystem', u'binary')
(u'character_set_results', u'utf8')
(u'character_set_server', u'utf8')
(u'character_set_system', u'utf8')
(u'character_sets_dir', u'/opt/mysql/mysql-5.1.41-osx10.5-x86_64/share/charsets/')

Should not use SET NAMES when connecting.

[Geert JM Vanderkelen (geertjmvdk)]

revno: 170
committer: Geert Vanderkelen <email address hidden>
branch nick: myconnpy-CHARSET
timestamp: Tue 2009-12-22 09:37:10 +0100
message:
  Fix setting character set at connection

  * mysql.connector.Connect(charset='latin1') now works as expected
  * Default character set is (still) UTF-8.
  * SET NAMES is only used when changing character set after connecting.
    Use MySQL.set_charset(charsetname) to change.
  * Test case added for bug report; fixing test case in test_protocol.py
    to reflect the new default character set 'utf-8'.