0

Hi,

I would like to know how to set a character set once and permanently, since when i alter the character_set% variables
that are shown on 'show varables like 'character_set%', when i alter them the next day they are back with the old values?

Thank you very much

2
Contributors
2
Replies
3
Views
5 Years
Discussion Span
Last Post by yanwick
0

The character set is a property of the server, the database, the table and the field - in that order. Each has a default which can be overwritten by the following. You can change it using the alter table syntax.
Then there is the client and the connection character set which define how the character set is translated on its way from the database to the end user. You can alter those by setting defaults in my.ini (or my.cnf) or by starting the mysql server with explicit values for those variables:

character_set_client
character_set_connection
character_set_database
character_set_filesystem
character_set_results
character_set_server
character_set_system
character_sets_dir

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.