Reference > Database > WebSphere Commerce database tables > L
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 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
-20 = Russian
-21 = Romanian
-22 = PolishLOCALENAME 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
ru_RU = Russian
ro_RO = Romanian
pl_PL = PolishLANGUAGE CHAR(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.COUNTRY CHAR(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.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 SQL100520030350310 LANGUAGE_ID Primary Key
Referenced By 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_3558 LANGUAGE_ID ATTRDESC LANGUAGE_ID Cascade F_3517 LANGUAGE_ID ATTRDICTGRPDESC LANGUAGE_ID Cascade F_71 LANGUAGE_ID ATTRIBUTE LANGUAGE_ID Cascade F_3561 LANGUAGE_ID ATTRVALDESC 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_3575 LANGUAGE_ID GEONDDS 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_3549 LANGUAGE_ID PX_DESCRIPTION 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_3571 LANGUAGE_ID STLOCATTR LANGUAGE_ID Cascade F_3573 LANGUAGE_ID STLOCDS 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
- Ship data model
- Calculation scale data model
- System data model
- Attribute data model
- Messaging extension data model
- Customer care data model
- Product set data model
- Quantity unit data model
- Authentication data model
- Store data model
- Tax type and category data model
- Order management - RMAitem data model
- Package data model
- Product Advisor data model
- Language data model
- Member data model
- Offers data model
- Order adjustment data model
- Order management adjustment and tax data model
- Order management - receipt and disposition data model
- Catalog data model
- Catalog entry data model
- Catalog group data model
- Country and state code data model
- Collateral and promotions data model
- Currency data model
- E-coupon data model
- Fulfillment data model
- Access control data model
- Auction data model
- Calculation code data model
- Contract data model
_vcc_freeselect_bottom_