How To Fix Corrupted Language Native Names Records
If you i18n_language table has been corrupted, you can update it with this SQL
Created by: Will, Last modification: 14 Dec 2007 (21:08 UTC)
On my mysql install the i18n_language native name records were corrupted with funny characters, probably the wrong the character set. This is sql I put together to update the table.
<?php
UPDATE i18n_languages SET native_name = "ﺎﻠﻋﺮﺒﻳﺓ" where lang_code="ar";
UPDATE i18n_languages SET native_name = "Português Brasileiro" where lang_code="br";
UPDATE i18n_languages SET native_name = "Český" where lang_code="cs";
UPDATE i18n_languages SET native_name = "Dansk" where lang_code="da";
UPDATE i18n_languages SET native_name = "Deutsch" where lang_code="de";
UPDATE i18n_languages SET native_name = "Greek" where lang_code="el";
UPDATE i18n_languages SET native_name = "British English" where lang_code="en-uk";
UPDATE i18n_languages SET native_name = "Español" where lang_code="es";
UPDATE i18n_languages SET native_name = "Suomi" where lang_code="fi";
UPDATE i18n_languages SET native_name = "Français" where lang_code="fr";
UPDATE i18n_languages SET native_name = "Hrvatski" where lang_code="hr";
UPDATE i18n_languages SET native_name = "Magyar" where lang_code="hu";
UPDATE i18n_languages SET native_name = "Italiano" where lang_code="it";
UPDATE i18n_languages SET native_name = "日本語" where lang_code="ja";
UPDATE i18n_languages SET native_name = "한국말" where lang_code="ko";
UPDATE i18n_languages SET native_name = "Nederlands" where lang_code="nl";
UPDATE i18n_languages SET native_name = "Norwegian" where lang_code="no";
UPDATE i18n_languages SET native_name = "Polish" where lang_code="pl";
UPDATE i18n_languages SET native_name = "Português" where lang_code="pt";
UPDATE i18n_languages SET native_name = "Português Brasileiro" where lang_code="pt-br";
UPDATE i18n_languages SET native_name = "Română" where lang_code="ro";
UPDATE i18n_languages SET native_name = "Russian" where lang_code="ru";
UPDATE i18n_languages SET native_name = "Pijin Solomon" where lang_code="sb";
UPDATE i18n_languages SET native_name = "Slovenský" where lang_code="sk";
UPDATE i18n_languages SET native_name = "Slovensko" where lang_code="sl";
UPDATE i18n_languages SET native_name = "Serbian" where lang_code="sr";
UPDATE i18n_languages SET native_name = "Srpski" where lang_code="sr-latn";
UPDATE i18n_languages SET native_name = "Svenska" where lang_code="sv";
UPDATE i18n_languages SET native_name = "Türkçe" where lang_code="tr";
UPDATE i18n_languages SET native_name = "Tuvaluan" where lang_code="tv";
UPDATE i18n_languages SET native_name = "中文(繁体字)" where lang_code="tw";
UPDATE i18n_languages SET native_name = "Українська" where lang_code="uk";
UPDATE i18n_languages SET native_name = "Việt" where lang_code="vi";
UPDATE i18n_languages SET native_name = "Chinese" where lang_code="zh-cn";
?>