We help IT Professionals succeed at work.

MySQL: what collation and storage engine to use?

DarkHill asked
Medium Priority
Last Modified: 2012-05-06
I'm starting a new (big) project in PHP that will cater for multiple languages (including Arabic). What would be the best:

1) Storage engine: InnoDB or MyISAM?
2) Collation?
Watch Question

Billing Engineer
Most Valuable Expert 2014
Top Expert 2009
>1) Storage engine: InnoDB or MyISAM?
that depends on your needs.
MyISAM is faster, but does not support features like transactions, foreign keys etc.

2) Collation?
also depends on your needs. for multiple languages, you need to specify UTF-8 or UTF-16

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts

I`d prefer InnoDB, because it allows to build more complex DB structure
and UTF-8 for multi-language support


OK, I've decided on utf8_general_ci as it's both case- and accent-insensitive which is great.

Now just to decide which storage engine to use...
Guy Hengel [angelIII / a3]Billing Engineer
Most Valuable Expert 2014
Top Expert 2009

as I wrote, there are some constraints for the MyISAM engine type.

note: you can mix engine types in your database, means you can create tables of MyISAM engine in the same database where you create InnoDB tables...
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.


Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.