If database is created in charset other than default charset, e.g. “latin1″, some characters may be displayed as “?” in the grid. To properly display non-English characters, such as Spanish, Fresh, or Chinese, in MySQL, PostgreSQL, and Oracle you can define the character set value in ‘DB_CHARSET’ variable in conf.php.
In conf.php, set the DB_CHARSET to the corresponding charsets in your database.
1 2 3 4 5 6 | define('DB_HOSTNAME','hostname'); // database host name define('DB_USERNAME', 'username'); // database user name define('DB_PASSWORD', 'password'); // database password define('DB_NAME', 'sampledb'); // database name define('DB_TYPE', 'mysql'); // database type define('DB_CHARSET','utf8'); // OPTIONAL. Leave blank to use the default charset |
Add the Meta element to the HTML head node and set character encoding to UTF-8. Note it’s important that the actual file must also be saved as UTF-8 encoding.
1 | <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /> |
