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

21.8.7.26 mysql_get_character_set_info()

void mysql_get_character_set_info(MYSQL *mysql, MY_CHARSET_INFO *cs)

Description

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

Example

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

if (!mysql_set_character_set(&mysql, "utf8"))
{
    MY_CHARSET_INFO cs;
    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", cs.name);
    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);
}

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.