Difference between revisions of "Features/Language-List-REQUEST"

Jump to navigation Jump to search
Line 18: Line 18:
<span style=" color: red">Vincent:</span> We should create another "written languages" list. I've found this: <span style=" color: red">https://en.wikipedia.org/wiki/List_of_languages_by_writing_system</span> but as we know Wikipedia is not a reliable source.... I will be suprised if Ethnologue does not have this table in their full dataset (to check if we can have it free).
<span style=" color: red">Vincent:</span> We should create another "written languages" list. I've found this: <span style=" color: red">https://en.wikipedia.org/wiki/List_of_languages_by_writing_system</span> but as we know Wikipedia is not a reliable source.... I will be suprised if Ethnologue does not have this table in their full dataset (to check if we can have it free).


====Written languages table====
Create a new table
{| class="wikitable"
  !|written_id
  !|name
|-
  |1
  |<span style=" color: red"><s>Mandarin</s></span> Chinese Simplified
|-
  |2
  |<span style=" color: red"><s>Mandarin</s></span> Chinese Traditional
|}
====Main table====
Attach the main table to the written language table so we can display written languages matching a user profile.
{| class="wikitable"
  !|iso
  !|name
  !|written_id
|-
  |yue
  |Yue Chinese
  |<span style=" color: red">1, 2</span>
|-
  |cmn
  |Mandarin Chinese
  |<span style=" color: red">1, 2</span>
|-
  |nan
  |Min Nan Chinese
  |<span style=" color: red">1, 2</span>
|}
====Database update====
For each language in the old list
{| class="wikitable"
  !|old
  !|new
  !|update
  !|written_id
|-
  |Chinese, mandarin
  |<span style=" color: red"><s>Mandarin</s></span> Chinese Simplified, <span style=" color: red"><s>Mandarin</s></span> Chinese Traditional
  |rename
  |<span style=" color: red">1, 2</span>
|-
  |Min (Taiwanese)
  |<span style=" color: red"><s>Mandarin</s></span> Chinese Simplified, <span style=" color: red"><s>Mandarin</s></span> Chinese Traditional
  |rename
  |<span style=" color: red">1, 2</span>
|}
<span style=" color: red">GrimPixel:</span> Yeah, new table for scripts. But there is a problem - Japanese uses both Kana and Chinese, Korean uses Hangul and sometimes Chinese. Also, both Traditional and Simplified Chinese are belonging to Chinese script. So it's not strictly according to script systems.
<span style=" color: red">GrimPixel:</span> Yeah, new table for scripts. But there is a problem - Japanese uses both Kana and Chinese, Korean uses Hangul and sometimes Chinese. Also, both Traditional and Simplified Chinese are belonging to Chinese script. So it's not strictly according to script systems.


Navigation menu