Re: START TRANSACTION charset problem
I tried different clients, Postman, Android Device and iOS device bu tit looks ok today.
This is the SHOW CREATE TABLE:
CREATE TABLE `places` (
`place_id` bigint(20) NOT NULL AUTO_INCREMENT,
`place_uuid` varchar(255) DEFAULT NULL,
`category` int(11) DEFAULT NULL,
`place_name_ar` varchar(255) DEFAULT NULL,
`place_name_en` varchar(255) DEFAULT NULL,
`description_ar` mediumtext,
`description_en` mediumtext,
`country_code` char(2) DEFAULT NULL,
`country_name` varchar(255) DEFAULT NULL,
`admin_area` varchar(255) DEFAULT NULL,
`sub_admin_area` varchar(255) DEFAULT NULL,
`locality` varchar(255) DEFAULT NULL,
`sub_locality` varchar(255) DEFAULT NULL,
`feature_name` varchar(255) DEFAULT NULL,
`thoroughfare` varchar(255) DEFAULT NULL,
`sub_thoroughfare` varchar(255) DEFAULT NULL,
`postal_code` varchar(255) DEFAULT NULL,
`city_name_ar` varchar(45) DEFAULT NULL,
`city_name_en` varchar(45) DEFAULT NULL,
`place_latitude` double DEFAULT NULL,
`place_longitude` double DEFAULT NULL,
`website` varchar(255) DEFAULT NULL,
`email_address` varchar(255) DEFAULT NULL,
`telephone` varchar(255) DEFAULT NULL,
`created_date` datetime DEFAULT NULL,
`created_user` bigint(20) DEFAULT NULL,
`created_ip` varchar(255) DEFAULT NULL,
PRIMARY KEY (`place_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1127 DEFAULT CHARSET=utf8mb4
How can I make sure this is a permanent configuration and not a temporary session?