MySQL Forums
Forum List  »  Spanish

Re: Problemas con busqueda de tildes
Posted by: William Chiquito
Date: July 18, 2007 09:43AM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
7607
July 18, 2007 08:43AM
Re: Problemas con busqueda de tildes
3943
July 18, 2007 09:43AM


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.