charset=utf-8, las tildes y eñes y utf8_spanish_ci

[aleluya]

Gracias por tu tiempo.

hice varias pruebas con el mismo resultado.

Código:

+----------+------------------------------------------------------------------+
| Database | Create Database                                                  |
+----------+------------------------------------------------------------------+
| dwcs3    | CREATE DATABASE `tildes` /*!40100 DEFAULT CHARACTER SET latin1 */ |

+----------+------------------------------------------------------------------+

mysql> show create database tildes
    -> ;
--------------------------------------------------------------------------------
-------+
| autores | CREATE TABLE `autores` (
  `autor_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `nombre` varchar(30) COLLATE latin1_spanish_ci DEFAULT NULL,
  `apellidos` varchar(30) COLLATE latin1_spanish_ci NOT NULL,
  PRIMARY KEY (`autor_id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1 COLLATE=latin1_spanish_
ci |
+---------+---------------------------------------------------------------------

Código:

+----------+------------------------------------------------------------------+
| dwcs3    | CREATE DATABASE `tildes` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE
 utf8_spanish_ci */ |
+----------+--------------------------------------------------------------------
--------------------+

+----------+------------------------------------------------------------------+
-----------------------------------------------------------------+
| autores | CREATE TABLE `autores` (
  `autor_id` int(7) NOT NULL AUTO_INCREMENT,
  `nombre` varchar(30) COLLATE utf8_spanish_ci NOT NULL,
  `apellidos` varchar(30) COLLATE utf8_spanish_ci NOT NULL,
  PRIMARY KEY (`autor_id`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci |