Hi,

I have one database with Mysql 4.1, this the code of one's table:

CREATE TABLE `articulo` (
`nombre` varchar(50) character set latin1 NOT NULL default '',
`resumen` text collate latin1_spanish_ci,
`ruta` varchar(100) collate latin1_spanish_ci default NULL,
`link` varchar(100) collate latin1_spanish_ci default NULL,
`estado` varchar(10) collate latin1_spanish_ci default NULL,
PRIMARY KEY (`nombre`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_spanish_ci;


All Databse have the charset latin1 and collate latin1_spanish_ci.
when I get the data, for example using a criterian all is ok. But when i use the update or save methods in the database the 'ñ' and 'á é í ó ú' converts to '?', i dont know why.

My Mysqld is configured all parameter with latin1 and latin1_spanish_ci.

I dont find the error.

Thanks.

[b]Hibernate version: 3.0

[b]Name and version of the database you are using: Mysql 4.1

try using utf-8.

espero que te ayude ! ;-)

I solve the probem with a Servlet Filter, using the req.setCharacterEncoding("ISO-8859-1");

If some have the same problem I hope that this solve the problem