Database Table: LANGUAGE

Each row of this table represents a language. WebSphere Commerce comes with ten languages, listed below. Users can add other supported languages by using the predefined ISO codes.

Column Name Column Type Column Description
COUNTRY CHARACTER (5)
NULL
Country or region component of the locale:
US = United States
FR = France
DE = Germany
IT = Italy
ES = Spain
BR = Brazil
CN = China
TW = Taiwan
KR = Korea
JP = Japan.

To choose another country or region, refer to the existing ISO codes.
ENCODING VARCHAR (32)
NULL
The character encoding value that the browser should use to display the page for this language.
LANGUAGE CHARACTER (5)
NULL
Language component of the locale:
en = English (US)
fr = French
de = German
it = Italian
es = Spanish
pt = Brazilian Portuguese
zh = Simplified Chinese
zh = Traditional Chinese
ko = Korean
ja = Japanese.

To choose another language component, refer to the existing ISO codes.
LANGUAGE_ID INTEGER
NOT NULL
A unique key for the language, used as part of the foreign key in tables that contain language-dependent information: Language component 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.
LOCALENAME CHARACTER (16)
NOT NULL
A Java locale used to represent a political, geographical, or cultural region that has a distinct language and customs 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.
MIMECHARSET VARCHAR (32)
NULL
The MIME character encoding value that the notification system will use to encode a message for this language.
VARIANT CHARACTER (10)
NULL
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.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416034952330 LANGUAGE_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
Not Applicable

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_1 LANGUAGE_ID ACACGPDESC LANGUAGE_ID Cascade
F_1008 LANGUAGE_ID ACPLGPDESC LANGUAGE_ID Cascade
F_1029 LANGUAGE_ID ROLEDESC LANGUAGE_ID Cascade
F_1031 LANGUAGE_ID MBRGRPDESC LANGUAGE_ID Cascade
F_109 LANGUAGE_ID BASEITMDSC LANGUAGE_ID Cascade
F_158 LANGUAGE_ID CALCODEDSC LANGUAGE_ID Cascade
F_180 LANGUAGE_ID CALSCALEDS LANGUAGE_ID Cascade
F_184 LANGUAGE_ID CATALOGDSC LANGUAGE_ID Cascade
F_195 LANGUAGE_ID CATENTATTR LANGUAGE_ID Cascade
F_197 LANGUAGE_ID CATENTDESC LANGUAGE_ID Cascade
F_218 LANGUAGE_ID CATGRPATTR LANGUAGE_ID Cascade
F_220 LANGUAGE_ID CATGRPDESC LANGUAGE_ID Cascade
F_237 LANGUAGE_ID CHRGTYPDSC LANGUAGE_ID Cascade
F_242 LANGUAGE_ID CLSFCODEDS LANGUAGE_ID Cascade
F_250 LANGUAGE_ID COLLDESC LANGUAGE_ID Cascade
F_257 LANGUAGE_ID COUNTRY LANGUAGE_ID Cascade
F_269 LANGUAGE_ID CPPMNDESC LANGUAGE_ID Cascade
F_28 LANGUAGE_ID ACPOLDESC LANGUAGE_ID Cascade
F_290 LANGUAGE_ID CURFMTDESC LANGUAGE_ID Cascade
F_297 LANGUAGE_ID DISPCGPREL LANGUAGE_ID Cascade
F_302 LANGUAGE_ID DISPENTREL LANGUAGE_ID Cascade
F_315 LANGUAGE_ID FFMCENTDS LANGUAGE_ID Cascade
F_321 LANGUAGE_ID FLDOMNDESC LANGUAGE_ID Cascade
F_329 LANGUAGE_ID FLOWDESC LANGUAGE_ID Cascade
F_337 LANGUAGE_ID FLSTDCTDSC LANGUAGE_ID Cascade
F_339 LANGUAGE_ID FLSTGPDSC LANGUAGE_ID Cascade
F_341 LANGUAGE_ID FLTRANSDSC LANGUAGE_ID Cascade
F_347 LANGUAGE_ID FLTYPEDESC LANGUAGE_ID Cascade
F_35 LANGUAGE_ID ACRELDESC LANGUAGE_ID Cascade
F_358 LANGUAGE_ID ICCONSTVAL LANGUAGE_ID Cascade
F_360 LANGUAGE_ID ICEXPLDESC LANGUAGE_ID Cascade
F_364 LANGUAGE_ID ICKNOWDESC LANGUAGE_ID Cascade
F_367 LANGUAGE_ID ICMERDESC LANGUAGE_ID Cascade
F_375 LANGUAGE_ID ICMREGDESC LANGUAGE_ID Cascade
F_389 LANGUAGE_ID INVADJDESC LANGUAGE_ID Cascade
F_400 LANGUAGE_ID INVRSRVDSC LANGUAGE_ID Cascade
F_413 LANGUAGE_ID LANGPAIR LANGUAGE_ID Cascade
F_414 LANGUAGE_ID LANGPAIR LANGUAGE_ID_ALT Cascade
F_416 LANGUAGE_ID LANGUAGEDS LANGUAGE_ID Cascade
F_417 LANGUAGE_ID LANGUAGEDS LANGUAGE_ID_DESC Cascade
F_42 LANGUAGE_ID ACRESGPDES LANGUAGE_ID Cascade
F_465 LANGUAGE_ID NUMBRUSGDS LANGUAGE_ID Cascade
F_471 LANGUAGE_ID OFFERDESC LANGUAGE_ID Cascade
F_481 LANGUAGE_ID OPERATRDSC LANGUAGE_ID Cascade
F_487 LANGUAGE_ID ORDADJDSC LANGUAGE_ID Cascade
F_5 LANGUAGE_ID ACACTDESC LANGUAGE_ID Cascade
F_53 LANGUAGE_ID ACRLGPDESC LANGUAGE_ID Cascade
F_556 LANGUAGE_ID OUTPUTQDSC LANGUAGE_ID Cascade
F_56 LANGUAGE_ID ACRSCGDES LANGUAGE_ID Cascade
F_562 LANGUAGE_ID PARTROLEDS LANGUAGE_ID Cascade
F_564 LANGUAGE_ID PATTRDESC LANGUAGE_ID Cascade
F_574 LANGUAGE_ID PAYMTHDDSC LANGUAGE_ID Cascade
F_589 LANGUAGE_ID PKGATTR LANGUAGE_ID Cascade
F_591 LANGUAGE_ID PKGATTRVAL LANGUAGE_ID Cascade
F_597 LANGUAGE_ID PLCYACCDSC LANGUAGE_ID Cascade
F_601 LANGUAGE_ID PLCYLCKDSC LANGUAGE_ID Cascade
F_603 LANGUAGE_ID PLCYPWDDSC LANGUAGE_ID Cascade
F_606 LANGUAGE_ID PLCYTYPDSC LANGUAGE_ID Cascade
F_611 LANGUAGE_ID POLICYDESC LANGUAGE_ID Cascade
F_620 LANGUAGE_ID PRODSETDSC LANGUAGE_ID Cascade
F_642 LANGUAGE_ID QTYFMTDESC LANGUAGE_ID Cascade
F_647 LANGUAGE_ID QTYUNITDSC LANGUAGE_ID Cascade
F_71 LANGUAGE_ID ATTRIBUTE LANGUAGE_ID Cascade
F_719 LANGUAGE_ID RTNDNYDESC LANGUAGE_ID Cascade
F_723 LANGUAGE_ID RTNDSPDESC LANGUAGE_ID Cascade
F_732 LANGUAGE_ID RTNRSNDESC LANGUAGE_ID Cascade
F_743 LANGUAGE_ID SETCURRDSC LANGUAGE_ID Cascade
F_756 LANGUAGE_ID SHPMODEDSC LANGUAGE_ID Cascade
F_758 LANGUAGE_ID STATEPROV LANGUAGE_ID Cascade
F_76 LANGUAGE_ID ATTRVALUE LANGUAGE_ID Cascade
F_777 LANGUAGE_ID STORE LANGUAGE_ID Cascade
F_79 LANGUAGE_ID AUCTDESC LANGUAGE_ID Cascade
F_793 LANGUAGE_ID STOREENTDS LANGUAGE_ID Cascade
F_798 LANGUAGE_ID STORELANG LANGUAGE_ID Cascade
F_809 LANGUAGE_ID STORLANGDS LANGUAGE_ID Cascade
F_819 LANGUAGE_ID TAXCGRYDS LANGUAGE_ID Cascade
F_825 LANGUAGE_ID TCDESC LANGUAGE_ID Cascade
F_829 LANGUAGE_ID TCSUBTYPDS LANGUAGE_ID Cascade
F_845 LANGUAGE_ID TFALGPOLDS LANGUAGE_ID Cascade
F_847 LANGUAGE_ID TFALGTYPDS LANGUAGE_ID Cascade
F_849 LANGUAGE_ID TFALREGDSC LANGUAGE_ID Cascade
F_851 LANGUAGE_ID TFDOMDSC LANGUAGE_ID Cascade
F_857 LANGUAGE_ID TFSBDOMDSC LANGUAGE_ID Cascade
F_861 LANGUAGE_ID TFTRENGDSC LANGUAGE_ID Cascade
F_873 LANGUAGE_ID TRDDESC LANGUAGE_ID Cascade
F_883 LANGUAGE_ID TRDTYPEDSC LANGUAGE_ID Cascade
F_897 LANGUAGE_ID USERS LANGUAGE_ID Cascade
F_9 LANGUAGE_ID ACATTRDESC LANGUAGE_ID Cascade
F_903 LANGUAGE_ID VENDORDESC LANGUAGE_ID Cascade
F_909 LANGUAGE_ID WCSDTNRYDS LANGUAGE_ID Cascade
F_920 LANGUAGE_ID STRELTYPDS LANGUAGE_ID Cascade
F_950 LANGUAGE_ID STCGRYDESC LANGUAGE_ID Cascade
F_953 LANGUAGE_ID QUEUEDESC LANGUAGE_ID Cascade