how to set mysql to use utf8 by default?

Question

I would like our centOS server 's mysql setup to use utf8 by default.

Can you tell me which file(s) need to be configured and how?

I know it's a pretty vague question but i'm not familiar with server management. Let me know if you need more details.

Thank you

score 2 · Accepted Answer · answered Sep 14 '09 at 04:14

2

At compile time use --with-charset=utf8 and --with-collation=utf8_general_ci options to configure.

When creating database or table use DEFAULT CHARACTER SET utf8.

answered Sep 14 '09 at 04:14

Max Kosyakov

score 1 · Answer 2 · edited Apr 13 '17 at 12:14

1

See this, this and this...

edited Apr 13 '17 at 12:14

Community

answered Sep 10 '09 at 21:31

igustin

2 Answers2