Change custom event types to UTF-8

From TNG_Wiki
Jump to navigation Jump to search

Sometimes people have to change to UTF-8 because of their language or other reasons. This is the one which worked for me but you will have to add the languages which aren't in this list and take away the languages which aren't in your list


UPDATE tng_eventtypes SET display = REPLACE(display, 'English', 'English-UTF8');
UPDATE tng_eventtypes SET display = REPLACE(display, 'afrikaans', 'Afrikaans-UTF8');
UPDATE tng_eventtypes SET display = REPLACE(display, 'German', 'German-UTF8');
UPDATE tng_eventtypes SET display = REPLACE(display, 'spanish', 'Spanish-UTF8');
UPDATE tng_eventtypes SET display = REPLACE(display, 'french', 'French-UTF8');
UPDATE tng_eventtypes SET display = REPLACE(display, 'Dutch', 'Dutch-UTF8');
UPDATE tng_eventtypes SET display = REPLACE(display, 'norwegian', 'Norwegian-UTF8');
UPDATE tng_eventtypes SET display = REPLACE(display, 'PortugueseBR', 'PortugueseBR-UTF8');
UPDATE tng_eventtypes SET display = REPLACE(display, 'finnish', 'Finnish-UTF8');