@@ -, +, @@ German translation - Run the database update - Verify that the new descriptions Tiếng Việt shows in advanced search language pull down - Install German translations - Verify that the German translation 'Vietnamesisch' shows in the pull down when German is selected. --- .../mysql/atomicupdate/bug_20082_fix_vietnamese_description.sql | 6 ++++++ installer/data/mysql/mandatory/subtag_registry.sql | 5 ++++- 2 files changed, 10 insertions(+), 1 deletion(-) create mode 100644 installer/data/mysql/atomicupdate/bug_20082_fix_vietnamese_description.sql --- a/installer/data/mysql/atomicupdate/bug_20082_fix_vietnamese_description.sql +++ a/installer/data/mysql/atomicupdate/bug_20082_fix_vietnamese_description.sql @@ -0,0 +1,6 @@ +INSERT IGNORE INTO language_descriptions(subtag, type, lang, description) + VALUES ('vi', 'language', 'de', 'Vietnamesisch'); +UPDATE language_descriptions SET description = 'Tiếng Việt' + WHERE subtag = 'vi' and type = 'language' and lang = 'vi'; + +-- print "Upgrade to $DBversion done (Bug 20082 - Update descriptions of Vietnamese language)\n"; --- a/installer/data/mysql/mandatory/subtag_registry.sql +++ a/installer/data/mysql/mandatory/subtag_registry.sql @@ -1136,11 +1136,14 @@ INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) VALUES ( 'vi','vie'); INSERT INTO language_descriptions(subtag, type, lang, description) -VALUES ( 'vi', 'language', 'vi', '㗂越'); +VALUES ( 'vi', 'language', 'vi', 'Tiếng Việt'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES ( 'vi', 'language', 'en', 'Vietnamese'); +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'vi', 'language', 'de', 'Vietnamesisch'); + -- Chinese INSERT INTO language_subtag_registry( subtag, type, description, added) VALUES ( 'zh', 'language', 'Chinese','2005-10-16'); --