hakanersu
7/5/2014 - 7:37 AM

Sql Turkish character replace

Sql Turkish character replace

UPDATE `tblclients` SET lastname = REPLACE (lastname,'ÄŸ', 'ğ');
UPDATE `tblclients` SET lastname = REPLACE (lastname,'ı', 'ı');
UPDATE `tblclients` SET lastname = REPLACE (lastname,'Ä°', 'İ');
UPDATE `tblclients` SET lastname = REPLACE (lastname,'Åž', 'Ş');
UPDATE `tblclients` SET lastname = REPLACE (lastname,'ÅŸ', 'ş');
UPDATE `tblclients` SET lastname = REPLACE (lastname,'ü', 'ü');
UPDATE `tblclients` SET lastname = REPLACE (lastname,'Ãœ', 'ü');
UPDATE `tblclients` SET lastname = REPLACE (lastname,'Ö', 'Ö');
UPDATE `tblclients` SET lastname = REPLACE (lastname,'Ç', 'Ç');
UPDATE `tblclients` SET lastname = REPLACE (lastname,'ç', 'ç');
UPDATE `tblclients` SET lastname = REPLACE (lastname,'ö', 'ö');
UPDATE `tblclients` SET lastname = REPLACE (lastname,'Äž', 'Ğ');