Re: Problemas con busqueda de tildes
Hola Andres,
Te recomiendo leer en la documetación de MySQL:
Chapter 10. Character Set Support
Mira mi ejemplo:
DROP TABLE IF EXISTS `t2`;
CREATE TABLE `t2` (
`tema` varchar(50) collate latin1_spanish_ci default NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_spanish_ci;
insert into `t2`(`tema`) values ('caceres');
insert into `t2`(`tema`) values ('cáceres');
select * from t2 where tema = 'caceres';
Result:
tema
--------
caceres
cáceres
select * from t2 where tema = 'cáceres';
Result:
tema
--------
caceres
cáceres
Edited 2 time(s). Last edit at 07/18/2007 09:44AM by William Chiquito.
Subject
Views
Written By
Posted
8034
July 18, 2007 08:43AM
Re: Problemas con busqueda de tildes
4147
July 18, 2007 09:43AM
3545
July 23, 2007 08:54AM
3350
July 24, 2007 06:29AM
3248
July 23, 2007 04:09PM
2957
July 23, 2007 07:11PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.