We help IT Professionals succeed at work.

MySQL: what collation and storage engine to use?

DarkHill
DarkHill asked
on
Medium Priority
682 Views
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?
Comment
Watch Question

Billing Engineer
CERTIFIED EXPERT
Most Valuable Expert 2014
Top Expert 2009
Commented:
>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

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

Author

Commented:
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
CERTIFIED EXPERT
Most Valuable Expert 2014
Top Expert 2009

Commented:
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.

OR

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.