MySQL: what collation and storage engine to use?

Posted on 2009-02-11
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
    LVL 142

    Accepted Solution

    >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
    LVL 3

    Expert Comment

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

    Author Comment

    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 142

    Expert Comment

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

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    Join & Write a Comment

    Suggested Solutions

    Introduction Since I wrote the original article about Handling Date and Time in PHP and MySQL ( several years ago, it seemed like now was a good time to updat…
    These days socially coordinated efforts have turned into a critical requirement for enterprises.
    This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.
    The viewer will learn how to create a basic form using some HTML5 and PHP for later processing. Set up your basic HTML file. Open your form tag and set the method and action attributes.: (CODE) Set up your first few inputs one for the name and …

    729 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

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now