Bug #24434 | my.cnf option: /mysqld: unknown variable 'character_set_database=utf8' | ||
---|---|---|---|
Submitted: | 19 Nov 2006 22:31 | Modified: | 20 Nov 2006 23:52 |
Reporter: | Roland Bouman | Email Updates: | |
Status: | Not a Bug | Impact on me: | |
Category: | MySQL Server | Severity: | S3 (Non-critical) |
Version: | 5.1.13, 5.1.14 bk | OS: | Linux (ubuntu etchy) |
Assigned to: | CPU Architecture: | Any | |
Tags: | character set, character_set_database, my.cnf |
[19 Nov 2006 22:31]
Roland Bouman
[19 Nov 2006 22:32]
Roland Bouman
my.cnf with unrecognized options
Attachment: my.cnf (application/octet-stream, text), 17.72 KiB.
[20 Nov 2006 23:52]
Sveta Smirnova
Thank you for taking the time to write to us, but this is not a bug. Please double-check the documentation available at http://dev.mysql.com/doc/ and the instructions on how to report a bug at http://bugs.mysql.com/how-to-report.php Please check of list of variables applicable to MySQL server at http://dev.mysql.com/doc/refman/5.1/en/mysqld-option-tables.html
[21 Nov 2006 3:24]
Roland Bouman
Sveta, thanks for the update. Of course, as always, I did look in the documentatin before submitting a bug. Can you please tell where I can find the piece of manual you are referring to? Thank you in advance Roland
[21 Nov 2006 7:22]
Sveta Smirnova
Roland, see previous comment, please.
[21 Nov 2006 11:52]
Roland Bouman
Thank you Sveta, my apologies for not noticing the link earlier on. I now understand that collation_database and character_set_database are read only server variables - not defaults that can be set. Setting the default database and collation should be done using the CREATE DATABASE ddl statement. Thanks for pointing it out, and sorry for posting a non-bug.