Attachment 72184 Details for Bug 20082 – Bug 20082: Correct description of Vietnamese language and add German translation

[patch] Bug 20082: Correct description of Vietnamese language and add German translation

Bug-20082-Correct-description-of-Vietnamese-langua.patch (text/plain), 2.71 KB, created by Josef Moravec on 2018-02-25 09:00:43 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Josef Moravec

Created: 2018-02-25 09:00:43 UTC

Size: 2.71 KB

patch

obsolete

>From 660c21108dc56f4dbe277f93d0ea637c584cfd7d Mon Sep 17 00:00:00 2001
>From: Katrin Fischer <katrin.fischer.83@web.de>
>Date: Thu, 1 Feb 2018 07:42:13 +0100
>Subject: [PATCH] Bug 20082: Correct description of Vietnamese language and add
> German translation
>MIME-Version: 1.0
>Content-Type: text/plain; charset=UTF-8
>Content-Transfer-Encoding: 8bit
>
>Fixes the language description of Vietnamese according to the
>bug report and adds the German translation for the language
>name.
>
>To test:
>- 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.
>
>Signed-off-by: Roch D'Amour <roch.damour@inlibro.com>
>
>Signed-off-by: Josef Moravec <josef.moravec@gmail.com>
>---
> .../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
>
>diff --git a/installer/data/mysql/atomicupdate/bug_20082_fix_vietnamese_description.sql b/installer/data/mysql/atomicupdate/bug_20082_fix_vietnamese_description.sql
>new file mode 100644
>index 0000000..d1a1f2d
>--- /dev/null
>+++ b/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";
>diff --git a/installer/data/mysql/mandatory/subtag_registry.sql b/installer/data/mysql/mandatory/subtag_registry.sql
>index e21577a..ebcdedc 100755
>--- a/installer/data/mysql/mandatory/subtag_registry.sql
>+++ b/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');
>-- 
>2.1.4

Actions: View | Diff | Splinter Review

Attachments on bug 20082: 71103 | 72160 | 72184