Documentation Home
MySQL 5.7 Reference Manual
Related Documentation Download this Manual Excerpts from this Manual

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

void mysql_get_character_set_info(MYSQL *mysql, MY_CHARSET_INFO *cs)


This function provides information about the default client character set. The default character set may be changed with the mysql_set_character_set() function.


This example shows the fields that are available in the MY_CHARSET_INFO structure:

if (!mysql_set_character_set(&mysql, "utf8"))
    mysql_get_character_set_info(&mysql, &cs);
    printf("character set information:\n");
    printf("character set+collation number: %d\n", cs.number);
    printf("character set name: %s\n",;
    printf("collation name: %s\n", cs.csname);
    printf("comment: %s\n", cs.comment);
    printf("directory: %s\n", cs.dir);
    printf("multi byte character min. length: %d\n", cs.mbminlen);
    printf("multi byte character max. length: %d\n", cs.mbmaxlen);

Download this Manual
User Comments
  Posted by Andy Dustman on March 3, 2006
Some of the string members of MY_CHARSET_INFO can be NULL, particularly dir.

csname and name seem to be reversed from what the documentation and mysql.h say: In my tests, csname has the character set name and name has the collation.
Sign Up Login You must be logged in to post a comment.