@womble is right. However, if you want some peace of mind you can set a few configuration options. Your mysql configuration file, my.cnf
, which, if you are using XAMPP is located at /Applications/XAMPP/etc/my.cnf
, or if you are using a standard installation is usually located at /etc/my.cnf
, has a section called [mysqld]
The default storage engine is MyISAM, but you can change it to InnoDB by adding this under that section:
[mysqld]
default-storage-engine = innodb
That will change what shows up in that last row:
If you are taking the time to make sure your database is really set up well, you might be interested in a few more items relating to setting the character set to utf-8 as well, because it is generally seen as a best practices for web development:
In your config.inc.php, which is located in your phpmyadmin folder, you can set these parameters:
// use utf_8 by default (the standard values on newer versions of pma)
// *******************************************************************
$cfg['DefaultCharset'] = 'utf_8';
//set a default Collation (utf8_general_ci is default on newer versions)
// *********************************************************************
$cfg['DefaultConnectionCollation'] = 'utf8_general_ci';
//use mysqli for security and, reading utf normally displayed with the BLOB type
// *****************************************************************************
$cfg['Servers'][$i]['extension'] = 'mysqli';
You can find all config options by visiting the PmaWiki or by looking at (but not changing!) the values in the this file: phpmyadmin/libraries/config.default.php
.
Using utf-8 is the new recommended standard with web applications, especially for applications where users may input words with different languages / keyboard sets. Check out some of the differences between the utf8_bin and utf8_general_ci character sets in this nice little post which should help you choose the right one.