Project

General

Profile

Actions

Feature #61542

closed

Add two-digit ISO 639-1 keys to sys_language

Added by Benni Mack over 9 years ago. Updated over 6 years ago.

Status:
Closed
Priority:
Should have
Assignee:
Category:
Localization
Target version:
Start date:
2014-09-11
Due date:
% Done:

100%

Estimated time:
PHP Version:
Tags:
Complexity:
Sprint Focus:

Description

The language handling of records in TYPO3
is solely based on UIDs of the sys_language DB table,
but no reference to the real language used.

The ISO 639-1 defines the language identifiers
(ISO language code) completely (182 entries).

If the real language key was needed before in
TYPO3, one could install static_info_tables
which takes a field ("static_lang_isocode") in the
various places of the TYPO3 Core and fetches
the isocode via separate SQL-Queries.

The change introduces the ISO language
two-letter-keys natively in the core in order to
1. use less SQL queries in FE and BE if
static_info_tables was installed
2. remove hard coded dependencies of
EXT:static_info_tables
3. and always ensure that the core
includes the ISO code

Additionally one can now use the
$TSFE->sys_language_isocode all the time for
working with the ISO code instead of the
UID parameter, meaning that isocode can now be
set with a TypoScript parameter as well.

A Migration Wizard moves values put in the old
DB field (which is a UID reference to
static_languages) to the new DB field "iso2code".

The old field is deprecated to use without the
new field filled "iso2code".

In TYPO3 CMS 8 the static_lang_isocode field
will be removed within the CMS core.


Related issues 4 (0 open4 closed)

Related to TYPO3 Core - Bug #22119: Include ISO_3166-1 alpha2 in sys_languagesClosed2010-02-14

Actions
Related to TYPO3 Core - Task #68616: Upgrade Wizard without installed ext:static_info_tables failesClosedAnja Leichsenring2015-07-29

Actions
Related to TYPO3 Core - Task #69929: Unsorted list of ISO codesClosed2015-09-18

Actions
Related to TYPO3 Core - Bug #81922: Upgrade Wizards: Field 'language_isocode' do not existsClosed2017-07-19

Actions
Actions

Also available in: Atom PDF