1
2company.default.locale=es_ES,en_US
3company.default.time.zone=Europe/Paris
4locales=es_ES,en_US

1    #
2    # This sets the default locale of the portal, overriding the properties
3    # "user.language" and "user.country" specified in system.properties.
4    #
5    #company.default.locale=en_US

 1    #
 2    # Specify the available locales. Messages corresponding to a specific
 3    # language are specified in properties files with file names matching that
 4    # of content/Language_*.properties. These values can also be overridden in
 5    # properties files with file names matching that of
 6    # content/Language-ext_*.properties. Use a comma to separate
 7    # each entry.
 8    #
 9    # If there is more than one locale for the same language, the first one in
10    # the list will be used when a translation is requested in another locale of
11    # the same language but a translated value cannot be found. For example, if
12    # there are two locales such us pt_BR and pt_PT (in this order), any key not
13    # found in pt_PT will be looked for in pt_BR.
14    #
15    # All locales must use UTF-8 encoding.
16    #
17    # See the following links specifiy language and country codes:
18    #     http://ftp.ics.uci.edu/pub/ietf/http/related/iso639.txt
19    #     http://userpage.chemie.fu-berlin.de/diverse/doc/ISO_3166.html
20    #
21    locales=ar_SA,eu_ES,bg_BG,ca_AD,ca_ES,zh_CN,zh_TW,hr_HR,cs_CZ,da_DK,nl_NL,nl_BE,en_US,en_GB,en_AU,et_EE,fi_FI,fr_FR,fr_CA,gl_ES,de_DE,el_GR,iw_IL,hi_IN,hu_HU,in_ID,it_IT,ja_JP,ko_KR,lo_LA,lt_LT,nb_NO,fa_IR,pl_PL,pt_BR,pt_PT,ro_RO,ru_RU,sr_RS,sr_RS_latin,sl_SI,sk_SK,es_ES,sv_SE,tr_TR,uk_UA,vi_VN

1select p.preferences
2from portalpreferences p, company c
3where p.ownerId = c.companyId;