LANGUAGE

Each row of this table represents a language. WebSphere Commerce supports multiple languages and is translated into ten languages by default. Using the predefined ISO codes users can add other supported languages.

Column Descriptions:

NameTypeDescription
LANGUAGE_IDINTEGER NOT NULLThe language ID (primary key of this table) for each language. Foreign key to the tables that contain language-dependent information. The following is the list of language components (language ID codes) of the locale: -1 = English (US) -2 = French -3 = German -4 = Italian -5 = Spanish -6 = Brazilian Portuguese -7 = Simplified Chinese -8 = Traditional Chinese -9 = Korean -10 = Japanese -20 = Russian -21 = Romanian -22 = Polish
LOCALENAMECHAR (16) NOT NULLA Java locale used to represent a political, geographical, or cultural region that has a distinct language and customs. The following is the list of locale used for formatting: en_US = United States fr_FR = France de_DE = Germany it_IT = Italy es_ES = Spain pt_BR = Brazil zh_CN = China zh_TW = Taiwan ko_KR = Korea ja_JP = Japan ru_RU = Russian ro_RO = Romanian pl_PL = Polish
LANGUAGECHAR (5)Language component of the locale. NOTE: A value must be entered for this column: en = English (US) fr = French de = German it = Italian es = Spanish pt = Brazilian Portuguese zh = Simplified Chinese zh = Traditional Chinese ko = Korean ja = Japanese ru = Russian ro = Romanian pl = Polish To choose another language component, refer to the existing ISO codes.
COUNTRYCHAR (5)Country or region component of the locale. NOTE: A value must be entered for this column: US = United States FR = France DE = Germany IT = Italy ES = Spain BR = Brazil CN = China TW = Taiwan KR = Korea JP = Japan RU = Russia RO = Romania PL = Poland To choose another country or region, refer to the existing ISO codes.
VARIANTCHAR (10)Variant component of the locale. Used to specify the locale encoding character set or to further segregate a distinct formatting custom for a political, geographical, or cultural region.
ENCODINGVARCHAR (32)The character encoding value that the browser uses to display the page in the selected language.
MIMECHARSETVARCHAR (32)The MIME character encoding value that the notification system uses to encode a message for the selected language.
OPTCOUNTERSMALLINTThe optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>LANGUAGE_IDPrimary Key

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_1LANGUAGE_IDACACGPDESCLANGUAGE_IDCascade
F_1008LANGUAGE_IDACPLGPDESCLANGUAGE_IDCascade
F_1029LANGUAGE_IDROLEDESCLANGUAGE_IDCascade
F_1031LANGUAGE_IDMBRGRPDESCLANGUAGE_IDCascade
F_109LANGUAGE_IDBASEITMDSCLANGUAGE_IDCascade
F_1106LANGUAGE_IDATCHTGTDSCLANGUAGE_IDCascade
F_1112LANGUAGE_IDATCHASTLGLANGUAGE_IDCascade
F_1117LANGUAGE_IDATCHRELDSCLANGUAGE_IDCascade
F_1121LANGUAGE_IDATCHRLUSDSLANGUAGE_IDCascade
F_1124LANGUAGE_IDCMFWKSPCDSCLANGUAGE_IDCascade
F_1126LANGUAGE_IDCMFTGDSCLANGUAGE_IDCascade
F_1132LANGUAGE_IDCMFTASKDSCLANGUAGE_IDCascade
F_1165LANGUAGE_IDCCOMMENTLANGUAGE_IDCascade
F_1167LANGUAGE_IDBUSCHNDESCLANGUAGE_IDCascade
F_1187LANGUAGE_IDDKPDCDESCLANGUAGE_IDCascade
F_1194LANGUAGE_IDTICKLERLANGUAGE_IDCascade
F_1200LANGUAGE_IDTKLACTHISTLANGUAGE_IDCascade
F_1204LANGUAGE_IDTKLRACTDSCLANGUAGE_IDCascade
F_1207LANGUAGE_IDTKLRRSNDSCLANGUAGE_IDCascade
F_1222LANGUAGE_IDBLKRSNDESCLANGUAGE_IDCascade
F_1234LANGUAGE_IDPRCORSNDSCLANGUAGE_IDCascade
F_158LANGUAGE_IDCALCODEDSCLANGUAGE_IDCascade
F_180LANGUAGE_IDCALSCALEDSLANGUAGE_IDCascade
F_184LANGUAGE_IDCATALOGDSCLANGUAGE_IDCascade
F_195LANGUAGE_IDCATENTATTRLANGUAGE_IDCascade
F_197LANGUAGE_IDCATENTDESCLANGUAGE_IDCascade
F_218LANGUAGE_IDCATGRPATTRLANGUAGE_IDCascade
F_220LANGUAGE_IDCATGRPDESCLANGUAGE_IDCascade
F_237LANGUAGE_IDCHRGTYPDSCLANGUAGE_IDCascade
F_242LANGUAGE_IDCLSFCODEDSLANGUAGE_IDCascade
F_250LANGUAGE_IDCOLLDESCLANGUAGE_IDCascade
F_257LANGUAGE_IDCOUNTRYLANGUAGE_IDCascade
F_269LANGUAGE_IDCPPMNDESCLANGUAGE_IDCascade
F_28LANGUAGE_IDACPOLDESCLANGUAGE_IDCascade
F_290LANGUAGE_IDCURFMTDESCLANGUAGE_IDCascade
F_297LANGUAGE_IDDISPCGPRELLANGUAGE_IDCascade
F_302LANGUAGE_IDDISPENTRELLANGUAGE_IDCascade
F_315LANGUAGE_IDFFMCENTDSLANGUAGE_IDCascade
F_321LANGUAGE_IDFLDOMNDESCLANGUAGE_IDCascade
F_329LANGUAGE_IDFLOWDESCLANGUAGE_IDCascade
F_337LANGUAGE_IDFLSTDCTDSCLANGUAGE_IDCascade
F_339LANGUAGE_IDFLSTGPDSCLANGUAGE_IDCascade
F_341LANGUAGE_IDFLTRANSDSCLANGUAGE_IDCascade
F_347LANGUAGE_IDFLTYPEDESCLANGUAGE_IDCascade
F_35LANGUAGE_IDACRELDESCLANGUAGE_IDCascade
F_3517LANGUAGE_IDATTRDICTGRPDESCLANGUAGE_IDCascade
F_3549LANGUAGE_IDPX_DESCRIPTIONLANGUAGE_IDCascade
F_3558LANGUAGE_IDATTRDESCLANGUAGE_IDCascade
F_3561LANGUAGE_IDATTRVALDESCLANGUAGE_IDCascade
F_3571LANGUAGE_IDSTLOCATTRLANGUAGE_IDCascade
F_3573LANGUAGE_IDSTLOCDSLANGUAGE_IDCascade
F_3575LANGUAGE_IDGEONDDSLANGUAGE_IDCascade
F_358LANGUAGE_IDICCONSTVALLANGUAGE_IDCascade
F_360LANGUAGE_IDICEXPLDESCLANGUAGE_IDCascade
F_364LANGUAGE_IDICKNOWDESCLANGUAGE_IDCascade
F_3665LANGUAGE_IDCATFLTDSCLANGUAGE_IDCascade
F_367LANGUAGE_IDICMERDESCLANGUAGE_IDCascade
F_3683LANGUAGE_IDCLSATTRSRCHCONFLANGUAGE_IDCascade
F_3685LANGUAGE_IDCFCONDVALLANGUAGE_IDCascade
F_3687LANGUAGE_IDSRCHTERMASSOCLANGUAGE_IDCascade
F_3699LANGUAGE_IDSEOPAGEDEFDESCLANGUAGE_IDCascade
F_3706LANGUAGE_IDSEOURLKEYWORDLANGUAGE_IDCascade
F_3709LANGUAGE_IDSRCHCONFEXTLANGUAGE_IDCascade
F_3722LANGUAGE_IDCATENTDESCOVRLANGUAGE_IDCascade
F_3738LANGUAGE_IDFACETDESCLANGUAGE_IDCascade
F_3743LANGUAGE_IDCOLLIMGMAPAREALANGUAGE_IDCascade
F_3745LANGUAGE_IDSRCHATTRDESCLANGUAGE_IDCascade
F_3748LANGUAGE_IDPLWIDGETDEFDESCLANGUAGE_IDCascade
F_375LANGUAGE_IDICMREGDESCLANGUAGE_IDCascade
F_389LANGUAGE_IDINVADJDESCLANGUAGE_IDCascade
F_400LANGUAGE_IDINVRSRVDSCLANGUAGE_IDCascade
F_413LANGUAGE_IDLANGPAIRLANGUAGE_IDCascade
F_414LANGUAGE_IDLANGPAIRLANGUAGE_ID_ALTCascade
F_416LANGUAGE_IDLANGUAGEDSLANGUAGE_IDCascade
F_417LANGUAGE_IDLANGUAGEDSLANGUAGE_ID_DESCCascade
F_42LANGUAGE_IDACRESGPDESLANGUAGE_IDCascade
F_465LANGUAGE_IDNUMBRUSGDSLANGUAGE_IDCascade
F_471LANGUAGE_IDOFFERDESCLANGUAGE_IDCascade
F_481LANGUAGE_IDOPERATRDSCLANGUAGE_IDCascade
F_487LANGUAGE_IDORDADJDSCLANGUAGE_IDCascade
F_5LANGUAGE_IDACACTDESCLANGUAGE_IDCascade
F_53LANGUAGE_IDACRLGPDESCLANGUAGE_IDCascade
F_556LANGUAGE_IDOUTPUTQDSCLANGUAGE_IDCascade
F_56LANGUAGE_IDACRSCGDESLANGUAGE_IDCascade
F_562LANGUAGE_IDPARTROLEDSLANGUAGE_IDCascade
F_564LANGUAGE_IDPATTRDESCLANGUAGE_IDCascade
F_574LANGUAGE_IDPAYMTHDDSCLANGUAGE_IDCascade
F_589LANGUAGE_IDPKGATTRLANGUAGE_IDCascade
F_591LANGUAGE_IDPKGATTRVALLANGUAGE_IDCascade
F_597LANGUAGE_IDPLCYACCDSCLANGUAGE_IDCascade
F_601LANGUAGE_IDPLCYLCKDSCLANGUAGE_IDCascade
F_603LANGUAGE_IDPLCYPWDDSCLANGUAGE_IDCascade
F_606LANGUAGE_IDPLCYTYPDSCLANGUAGE_IDCascade
F_611LANGUAGE_IDPOLICYDESCLANGUAGE_IDCascade
F_620LANGUAGE_IDPRODSETDSCLANGUAGE_IDCascade
F_642LANGUAGE_IDQTYFMTDESCLANGUAGE_IDCascade
F_647LANGUAGE_IDQTYUNITDSCLANGUAGE_IDCascade
F_71LANGUAGE_IDATTRIBUTELANGUAGE_IDCascade
F_719LANGUAGE_IDRTNDNYDESCLANGUAGE_IDCascade
F_723LANGUAGE_IDRTNDSPDESCLANGUAGE_IDCascade
F_732LANGUAGE_IDRTNRSNDESCLANGUAGE_IDCascade
F_743LANGUAGE_IDSETCURRDSCLANGUAGE_IDCascade
F_756LANGUAGE_IDSHPMODEDSCLANGUAGE_IDCascade
F_758LANGUAGE_IDSTATEPROVLANGUAGE_IDCascade
F_76LANGUAGE_IDATTRVALUELANGUAGE_IDCascade
F_777LANGUAGE_IDSTORELANGUAGE_IDCascade
F_79LANGUAGE_IDAUCTDESCLANGUAGE_IDCascade
F_793LANGUAGE_IDSTOREENTDSLANGUAGE_IDCascade
F_798LANGUAGE_IDSTORELANGLANGUAGE_IDCascade
F_809LANGUAGE_IDSTORLANGDSLANGUAGE_IDCascade
F_819LANGUAGE_IDTAXCGRYDSLANGUAGE_IDCascade
F_825LANGUAGE_IDTCDESCLANGUAGE_IDCascade
F_829LANGUAGE_IDTCSUBTYPDSLANGUAGE_IDCascade
F_845LANGUAGE_IDTFALGPOLDSLANGUAGE_IDCascade
F_847LANGUAGE_IDTFALGTYPDSLANGUAGE_IDCascade
F_849LANGUAGE_IDTFALREGDSCLANGUAGE_IDCascade
F_851LANGUAGE_IDTFDOMDSCLANGUAGE_IDCascade
F_857LANGUAGE_IDTFSBDOMDSCLANGUAGE_IDCascade
F_861LANGUAGE_IDTFTRENGDSCLANGUAGE_IDCascade
F_873LANGUAGE_IDTRDDESCLANGUAGE_IDCascade
F_883LANGUAGE_IDTRDTYPEDSCLANGUAGE_IDCascade
F_897LANGUAGE_IDUSERSLANGUAGE_IDCascade
F_9LANGUAGE_IDACATTRDESCLANGUAGE_IDCascade
F_903LANGUAGE_IDVENDORDESCLANGUAGE_IDCascade
F_909LANGUAGE_IDWCSDTNRYDSLANGUAGE_IDCascade
F_920LANGUAGE_IDSTRELTYPDSLANGUAGE_IDCascade
F_950LANGUAGE_IDSTCGRYDESCLANGUAGE_IDCascade
F_953LANGUAGE_IDQUEUEDESCLANGUAGE_IDCascade