paBSBzUb

1--
2-- Estructura para la tabla `tabla_latin1` con datos insertados en UTF8
3--
4
5DROP TABLE IF EXISTS `tabla_latin1`;
6CREATE TABLE IF NOT EXISTS `tabla_latin1` (
7  `idTabla` int(11) NOT NULL AUTO_INCREMENT,
8  `texto` varchar(255) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
9  PRIMARY KEY (`idTabla`)
10) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
11
12--
13-- Volcado de datos para la tabla `tabla_latin1`
14--
15
16INSERT INTO `tabla_latin1` (`idTabla`, `texto`) VALUES
17(1, 'Ç'),
18(2, 'È'),
19(3, 'É'),
20(4, 'Ê'),
21(5, 'Ë'),
22(6, 'Ì'),
23(7, 'Ã'),
24(8, 'ÃŽ'),
25(9, 'Ã'),
26(10, 'Ã'),
27(11, 'Ñ'),
28(12, 'Ã’'),
29(13, 'Ó'),
30(14, 'Ô'),
31(15, 'Õ'),
32(16, 'Ö');
33
34--
35-- datos correctos: ÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖ
36--