· 8 years ago · Aug 31, 2018, 08:26 PM
1Trouble with encondig in Mysql
2CREATE TABLE IF NOT EXISTS `applications` (
3 `id` int(11) NOT NULL AUTO_INCREMENT,
4 `name` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
5PRIMARY KEY (`id`)
6) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
7
8mysql_set_charset("UTF-8");
9
10echo mysql_client_encoding($con);
11
12print_r(mysql_fetch_assoc(mysql_query("show variables like 'char%';")));
13
14mysql_set_charset("utf8");
15
16mysql_query("SET CHARACTER SET 'UTF8'", $con); // data send by the server
17mysql_query("SET NAMES 'UTF8'", $con); // data send by the client