WebSphere Commerce database table: 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
Column Name Column Type Description
LANGUAGE_ID INTEGER NOT NULL The 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
LOCALENAME CHAR(16) NOT NULL A 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
LANGUAGE CHAR(5) 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.
COUNTRY CHAR(5) 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.
VARIANT CHAR(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.
ENCODING VARCHAR(32) The character encoding value that the browser uses to display the page in the selected language.
MIMECHARSET VARCHAR(32) The MIME character encoding value that the notification system uses to encode a message for the selected language.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235210560 LANGUAGE_ID Primary Key

Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_1 LANGUAGE_ID ACACGPDESC LANGUAGE_ID Cascade
F_5 LANGUAGE_ID ACACTDESC LANGUAGE_ID Cascade
F_9 LANGUAGE_ID ACATTRDESC LANGUAGE_ID Cascade
F_1008 LANGUAGE_ID ACPLGPDESC LANGUAGE_ID Cascade
F_28 LANGUAGE_ID ACPOLDESC LANGUAGE_ID Cascade
F_35 LANGUAGE_ID ACRELDESC LANGUAGE_ID Cascade
F_42 LANGUAGE_ID ACRESGPDES LANGUAGE_ID Cascade
F_53 LANGUAGE_ID ACRLGPDESC LANGUAGE_ID Cascade
F_56 LANGUAGE_ID ACRSCGDES LANGUAGE_ID Cascade
F_1112 LANGUAGE_ID ATCHASTLG LANGUAGE_ID Cascade
F_1117 LANGUAGE_ID ATCHRELDSC LANGUAGE_ID Cascade
F_1121 LANGUAGE_ID ATCHRLUSDS LANGUAGE_ID Cascade
F_1106 LANGUAGE_ID ATCHTGTDSC LANGUAGE_ID Cascade
F_71 LANGUAGE_ID ATTRIBUTE LANGUAGE_ID Cascade
F_76 LANGUAGE_ID ATTRVALUE LANGUAGE_ID Cascade
F_79 LANGUAGE_ID AUCTDESC LANGUAGE_ID Cascade
F_109 LANGUAGE_ID BASEITMDSC LANGUAGE_ID Cascade
F_1222 LANGUAGE_ID BLKRSNDESC LANGUAGE_ID Cascade
F_1167 LANGUAGE_ID BUSCHNDESC 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_1165 LANGUAGE_ID CCOMMENT LANGUAGE_ID Cascade
F_237 LANGUAGE_ID CHRGTYPDSC LANGUAGE_ID Cascade
F_242 LANGUAGE_ID CLSFCODEDS LANGUAGE_ID Cascade
F_1132 LANGUAGE_ID CMFTASKDSC LANGUAGE_ID Cascade
F_1126 LANGUAGE_ID CMFTGDSC LANGUAGE_ID Cascade
F_1124 LANGUAGE_ID CMFWKSPCDSC 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_290 LANGUAGE_ID CURFMTDESC LANGUAGE_ID Cascade
F_297 LANGUAGE_ID DISPCGPREL LANGUAGE_ID Cascade
F_302 LANGUAGE_ID DISPENTREL LANGUAGE_ID Cascade
F_1187 LANGUAGE_ID DKPDCDESC 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_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_ALT LANGPAIR LANGUAGE_ID Cascade
F_416 LANGUAGE_ID LANGUAGEDS LANGUAGE_ID Cascade
F_417 LANGUAGE_ID_DESC LANGUAGEDS LANGUAGE_ID Cascade
F_1031 LANGUAGE_ID MBRGRPDESC 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_556 LANGUAGE_ID OUTPUTQDSC 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_1234 LANGUAGE_ID PRCORSNDSC 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_953 LANGUAGE_ID QUEUEDESC LANGUAGE_ID Cascade
F_1029 LANGUAGE_ID ROLEDESC 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_950 LANGUAGE_ID STCGRYDESC LANGUAGE_ID Cascade
F_777 LANGUAGE_ID STORE 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_920 LANGUAGE_ID STRELTYPDS 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_1194 LANGUAGE_ID TICKLER LANGUAGE_ID Cascade
F_1200 LANGUAGE_ID TKLACTHIST LANGUAGE_ID Cascade
F_1204 LANGUAGE_ID TKLRACTDSC LANGUAGE_ID Cascade
F_1207 LANGUAGE_ID TKLRRSNDSC 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_903 LANGUAGE_ID VENDORDESC LANGUAGE_ID Cascade
F_909 LANGUAGE_ID WCSDTNRYDS LANGUAGE_ID Cascade
Related reference