| Bug #19814 | Please could the possible values for charsetnr in MYSQL_FIELD be documented | ||
|---|---|---|---|
| Submitted: | 15 May 2006 12:38 | Modified: | 21 Jun 2006 6:34 |
| Reporter: | Martin Evans | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server: Documentation | Severity: | S3 (Non-critical) |
| Version: | 5.0.15/4.1/5.1 | OS: | Any (All) |
| Assigned to: | MC Brown | CPU Architecture: | Any |
[15 May 2006 17:02]
MySQL Verification Team
Thank you for the bug report.
[21 Jun 2006 6:34]
MC Brown
I've now added a section into Chapter 4 of the Internals manual with details on the charsetnr field and character sets in general. You can find the new documentation here: http://dev.mysql.com/doc/internals/en/charsets.html To address one of your specific points, the documentation includes a note about the correlation between charsetnr, character set names, and collation names, and hopefully should explain why different charsetnr values return identical character set name information.
Description: Please could the possible values for charsetnr in MYSQL_FIELD be documented. As in the MYSQL_FIELD defined in mysq.h typedef struct st_mysql_field { char *name; /* Name of column */ char *org_name; /* Original column name, if an alias */ char *table; /* Table of column if column was a field */ char *org_table; /* Org table name, if table was an alias */ char *db; /* Database for table */ char *catalog; /* Catalog for table */ char *def; /* Default value (set by mysql_list_fields) */ unsigned long length; /* Width of column (create length) */ unsigned long max_length; /* Max width for selected set */ unsigned int name_length; unsigned int org_name_length; unsigned int table_length; unsigned int org_table_length; unsigned int db_length; unsigned int catalog_length; unsigned int def_length; unsigned int flags; /* Div flags */ unsigned int decimals; /* Number of decimals in field */ unsigned int charsetnr; /* Character set */ enum enum_field_types type; /* Type of field. See mysql_com.h for types */ } MYSQL_FIELD; and used by calls such as get_charset() in the mysqlclient. In particular, multiple charsetnr values seem to return "utf8" when passed in to get_charset(). What are the differences between them? How to repeat: Documentation issue