Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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

share|improve this question
add comment

2 Answers

up vote 2 down vote accepted

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.

It's in the manual! http://dev.mysql.com/doc/refman/5.0/en/create-database.html

share|improve this answer
add comment

See this, this and this...

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.