Re: Coding UTF-8 / Czech

[Stepan Vesely]

SHOW CREATE DATABASE prestashop_03

Database Create Database

prestashop_03 CREATE DATABASE `prestashop_03` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_czech_ci */


SHOW CREATE TABLE ps_configuration

Table Create Table
ps_configuration

CREATE TABLE `ps_configuration` (
`id_configuration` int(10) unsigned NOT NULL AUTO_INCREMENT,
`id_shop_group` int(11) unsigned DEFAULT NULL,
`id_shop` int(11) unsigned DEFAULT NULL,
`name` varchar(254) COLLATE utf8_czech_ci NOT NULL,
`value` text COLLATE utf8_czech_ci,
`date_add` datetime NOT NULL,
`date_upd` datetime NOT NULL,
PRIMARY KEY (`id_configuration`),
KEY `name` (`name`),
KEY `id_shop` (`id_shop`),
KEY `id_shop_group` (`id_shop_group`)
) ENGINE=InnoDB AUTO_INCREMENT=372 DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci