Documentation Home
MySQL 5.7 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 35.7Mb
PDF (A4) - 35.7Mb
PDF (RPM) - 34.8Mb
EPUB - 8.7Mb
HTML Download (TGZ) - 8.5Mb
HTML Download (Zip) - 8.5Mb
HTML Download (RPM) - 7.3Mb
Eclipse Doc Plugin (TGZ) - 9.3Mb
Eclipse Doc Plugin (Zip) - 11.5Mb
Man Pages (TGZ) - 203.5Kb
Man Pages (Zip) - 308.9Kb
Info (Gzip) - 3.4Mb
Info (Zip) - 3.4Mb
Excerpts from this Manual

MySQL 5.7 Reference Manual  /  ...  /  mysql_character_set_name()

25.8.7.4 mysql_character_set_name()

const char *mysql_character_set_name(MYSQL *mysql)

Description

Returns the default character set name for the current connection.

Return Values

The default character set name

Errors

None.


User Comments
  Posted by Andy Dustman on January 5, 2005
With MySQL-4.0, mysql_character_set_name() does what you expect:

>>> import MySQLdb
>>> db=MySQLdb.connect(read_default_file="~/.my.cnf")
>>> db.character_set_name()
'latin1'

With MySQL-4.1, mysql_character_set_name() returns the collation, and not the character set name:

>>> import MySQLdb
>>> db=MySQLdb.connect(read_default_file="~/.my.cnf")
>>> db.character_set_name()
'latin1_swedish_ci'

Tip or bug? Leaning towards bug. Note that examples are with MySQL-python-1.1.8; the first example is with MySQL-4.0.22, and the second with with 4.1.8.
  Posted by Andy Dustman on January 18, 2005
The problem above is supposedly fixed in 4.1.9 and 5.0.3.
  Posted by Daniel Murray on March 4, 2005
I'm having this problem with 4.1.10-nt-log. It's very frustrating, I spent ages trying to work out what was going on! I got around it (in MySQLdb) by changing the line in connections.py that says self.charset = self.character_set_name().split('_')[0] to read self.charset = 'utf8'. It's messy, obviously, but it works for me.
Sign Up Login You must be logged in to post a comment.