Hi,
this is not the mapping of the language Ids. The language ids depend on
the order in which languages are added to oxid. If you install English
first and than later add German, the mapping is 0 = English, 1 = German
If you do it the other way round the mapping is 0 = German, 1 = English
Now how can one get this mapping?
We often need it because we need to import and /or export data depending
on the language.
Normally you can map the isoCode to the created views but not in all
cases you can use this.
The language mapping is stored in "oxconfig" table as a serialized Array
("aLanguages" for the titles and "aLanguageParams" for meta data).
For now, we extract the data and put it into a separate Table.
The problem is, that you need PHP to unserialze that array.
We'd prefer Json instead of a serialized php array or (better) move this
mapping to an own table.
One use case: solr grabs data from mysql as the direct data source
(without php)
Best regards,
Daniel Schlichtholz
Am 08.03.2012 08:55, schrieb Alfonsas Cirtautas:
> Hello,
>
> select oxid, oxisoalpha2, oxisoalpha3 from oxcountry;
>
> Alf.
> ________________________________________
> From: [email protected]
> [[email protected]] on behalf of Stefan Krenz
> [[email protected]]
> Sent: Wednesday, March 07, 2012 12:44 PM
> To: [email protected]
> Subject: [oxid-dev-general] Mapping OXID language ID to ISO-Code
>
> Dear dev-list,
>
> is there a way to get the language mapping (OXID lang ID to ISO-Code) in
> plain SQL?
>
> Best regards
> Stefan Krenz
>
>
> --
> Stefan Krenz Mayflower GmbH
> Gneisenaustraße 10/11 Tel.: +49 931 359 65 1163
> D-97074 Würzburg Fax : +49 931 359 65 28
> [email protected] http://www.mayflower.de
>
> Mayflower GmbH, Standort Würzburg
> Firmensitz: Mannhardtstraße 6, 80538 München
> Registergericht: Amtsgericht München, HRB 142039
> Geschäftsführer: Gregor Streng, Björn Schotte,
> Albrecht Günther, Johann-Peter Hartmann
> _______________________________________________
> dev-general mailing list
> [email protected]
> http://dir.gmane.org/gmane.comp.php.oxid.general
> _______________________________________________
> dev-general mailing list
> [email protected]
> http://dir.gmane.org/gmane.comp.php.oxid.general
_______________________________________________
dev-general mailing list
[email protected]
http://dir.gmane.org/gmane.comp.php.oxid.general
