José Manuel Usuario001

Software Engineer

wilxsv / change.sql

Created June 19, 2018 15:44

Reemplazar acentos y caracteres especiales en mysql

	UPDATE TABLA SET CAMPO = REPLACE(CAMPO,'Á','A');
	UPDATE TABLA SET CAMPO = REPLACE(CAMPO,'É','E');
	UPDATE TABLA SET CAMPO = REPLACE(CAMPO,'Í','I');
	UPDATE TABLA SET CAMPO = REPLACE(CAMPO,'Ó','O');
	UPDATE TABLA SET CAMPO = REPLACE(CAMPO,'Ú','U');
	UPDATE TABLA SET CAMPO = REPLACE(CAMPO,'Ñ','N');

	UPDATE TABLA SET CAMPO = REPLACE(CAMPO,'ã','a');
	UPDATE TABLA SET CAMPO = REPLACE(CAMPO,'ä','a');
	UPDATE TABLA SET CAMPO = REPLACE(CAMPO,'å','a');