MySQL: what collation and storage engine to use?

Posted on 2009-02-11
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?
Question by:DarkHill
  • 2
LVL 143

Accepted Solution

Guy Hengel [angelIII / a3] earned 2000 total points
ID: 23610245
>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

Expert Comment

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

Author Comment

ID: 23610445
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...
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 23611055
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...

Featured Post

Fill in the form and get your FREE NFR key NOW!

Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article discusses how to implement server side field validation and display customized error messages to the client.
This post looks at MongoDB and MySQL, and covers high-level MongoDB strengths, weaknesses, features, and uses from the perspective of an SQL user.
The viewer will learn how to dynamically set the form action using jQuery.
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses
Course of the Month15 days, 23 hours left to enroll

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question