el código es el siguiente
el error que sale es:
Illegal mix of collations (utf8mb4_spanish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
la estructuta de la tabla es:
--
-- Estructura de tabla para la tabla `basico`
--
CREATE TABLE IF NOT EXISTS `basico` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`titulo1_barra1` char(11) COLLATE utf8mb4_spanish_ci NOT NULL,
`texto1_barra1` longtext COLLATE utf8mb4_spanish_ci NOT NULL,
`titulo2_barra1` char(11) COLLATE utf8mb4_spanish_ci NOT NULL,
`texto2_barra1` longtext COLLATE utf8mb4_spanish_ci NOT NULL,
`titulo3_barra1` char(11) COLLATE utf8mb4_spanish_ci NOT NULL,
`texto3_barra1` longtext COLLATE utf8mb4_spanish_ci NOT NULL,
`titulo4_barra1` char(11) COLLATE utf8mb4_spanish_ci NOT NULL,
`texto4_barra1` longtext COLLATE utf8mb4_spanish_ci NOT NULL,
`titulo5_barra1` char(11) COLLATE utf8mb4_spanish_ci NOT NULL,
`texto5_barra1` longtext COLLATE utf8mb4_spanish_ci NOT NULL,
`titulo6_barra1` char(11) COLLATE utf8mb4_spanish_ci NOT NULL,
`texto6_barra1` longtext COLLATE utf8mb4_spanish_ci NOT NULL,
`titulo_derecho1` varchar(21) COLLATE utf8mb4_spanish_ci NOT NULL,
`titulo_derecho2` varchar(21) COLLATE utf8mb4_spanish_ci NOT NULL,
`titulo_derecho3` varchar(21) COLLATE utf8mb4_spanish_ci NOT NULL,
`titulo_derecho4` varchar(21) COLLATE utf8mb4_spanish_ci NOT NULL,
`texto_derecho4` tinytext COLLATE utf8mb4_spanish_ci NOT NULL,
`titulo_general` varchar(35) COLLATE utf8mb4_spanish_ci NOT NULL,
`tc_general` mediumtext COLLATE utf8mb4_spanish_ci NOT NULL,
`texto_general` longtext COLLATE utf8mb4_spanish_ci NOT NULL,
`titulo1` varchar(15) COLLATE utf8mb4_spanish_ci NOT NULL,
`titulo2` varchar(15) COLLATE utf8mb4_spanish_ci NOT NULL,
`tc_titulo1` varchar(255) COLLATE utf8mb4_spanish_ci NOT NULL,
`tc_titulo2` varchar(255) COLLATE utf8mb4_spanish_ci NOT NULL,
`titulo_contacto` varchar(100) COLLATE utf8mb4_spanish_ci NOT NULL,
`texto_contacto` varchar(255) COLLATE utf8mb4_spanish_ci NOT NULL,
`titulo_formulario` varchar(150) COLLATE utf8mb4_spanish_ci NOT NULL,
`tit1_contac` varchar(50) COLLATE utf8mb4_spanish_ci NOT NULL,
`tit2_contac` varchar(50) COLLATE utf8mb4_spanish_ci NOT NULL,
`tit3_contac` varchar(50) COLLATE utf8mb4_spanish_ci NOT NULL,
`tit4_contac` varchar(50) COLLATE utf8mb4_spanish_ci NOT NULL,
`titulo_propiedades` varchar(255) COLLATE utf8mb4_spanish_ci NOT NULL,
`titulo_publicacion` varchar(256) COLLATE utf8mb4_spanish_ci NOT NULL,
`texto_publicacion` longtext COLLATE utf8mb4_spanish_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_spanish_ci AUTO_INCREMENT=2 ;
gracias
siREZ
