Turkish Charset Problem UTF8 How to SMF Database Butch Bulk Replace Characters


UPDATE `smf_messages` SET `body` = REPLACE(`body`,"Åz","Ş" );
UPDATE `smf_messages` SET `body` = REPLACE(`body`,"Äz","Ğ" );
UPDATE `smf_messages` SET `body` = REPLACE(`body`,"äÿ","ğ" );
UPDATE `smf_messages` SET `body` = REPLACE(`body`,"Ç","Ç" );
UPDATE `smf_messages` SET `body` = REPLACE(`body`,"Ä°","İ" );
UPDATE `smf_messages` SET `body` = REPLACE(`body`,"ä°","i" );
UPDATE `smf_messages` SET `body` = REPLACE(`body`,"Ö","Ö" );
UPDATE `smf_messages` SET `body` = REPLACE(`body`,"ü","ü" );
UPDATE `smf_messages` SET `body` = REPLACE(`body`,"ÅŸ","ş" );
UPDATE `smf_messages` SET `body` = REPLACE(`body`,"åÿ","ş" );
UPDATE `smf_messages` SET `body` = REPLACE(`body`,"ÄŸ","ğ" );
UPDATE `smf_messages` SET `body` = REPLACE(`body`,"ç","ç" );
UPDATE `smf_messages` SET `body` = REPLACE(`body`,"ã§","ç" );
UPDATE `smf_messages` SET `body` = REPLACE(`body`,"ı","ı" );
UPDATE `smf_messages` SET `body` = REPLACE(`body`,"ä±","ı" );
UPDATE `smf_messages` SET `body` = REPLACE(`body`,"ö","ö" );
UPDATE `smf_messages` SET `body` = REPLACE(`body`,"ã¶","ö" );

One thought on “Turkish Charset Problem UTF8 How to SMF Database Butch Bulk Replace Characters

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s