Documentation Home
MySQL 5.6 リファレンスマニュアル
Download this Manual
PDF (US Ltr) - 27.1Mb
PDF (A4) - 27.1Mb
HTML Download (TGZ) - 7.2Mb
HTML Download (Zip) - 7.2Mb


23.8.7.4 mysql_character_set_name()

const char *mysql_character_set_name(MYSQL *mysql)

説明

現在の接続のデフォルトの文字セット名を返します。

戻り値

デフォルトの文字セット名

エラー

なし。


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.