Skip to main content

A user-defined function for culturally correct collation in DB2 UDB


Return to article

Table 2 lists the valid locale names for the collation. All the collations conform to version 1.2 of the Common Locale Data Repository (CLDR), as published by the Unicode Consortium Web site. The "Default collation attributes" column shows the full name of the collation for the specific locale. For example, LAR is equivalent to LAR_AN_CX_EX_FX_HX_NX_S3.


Table 2. Valid locales for collation names
Locale nameLanguageRegionDefault collation attributesRemarks
LARArabic
LAR_AN_CX_EX_FX_HX_NX_S3"
LBEBelarusian
LBE_AN_CX_EX_FX_HX_NX_S3Identical to LRU
LBGBulgarian
LBG_AN_CX_EX_FX_HX_NX_S3Identical to LRU
LCAValencian; Catalan
LCA_AN_CX_EX_FO_HX_NX_S3"
LCSCzech
LCS_AN_CX_EX_FX_HX_NX_S3"
LDADanish
LDA_AN_CU_EX_FX_HX_NX_S3"
LDEGerman
LDE_AN_CX_EX_FX_HX_NX_S3"
LDE_KPHONEBOOKGerman
LDE_KPHONEBOOK_AN_CX_EX_FX_HX_NX_S3"
LELGreek, Modern
LEL_AN_CX_EX_FX_HX_NO_S3Identical to LROOT_NO
LENEnglish
LEN_AN_CX_EX_FX_HX_NX_S3"
LEN_RBEEnglishBelgiumLEN_RBE_AN_CX_EX_FO_HX_NX_S3"
LEOEsperanto
LEO_AN_CX_EX_FX_HX_NX_S3"
LESCastilian; Spanish
LES_AN_CX_EX_FX_HX_NX_S3"
LES_KTRADITIONALCastilian; Spanish
LES_KTRADITIONAL_AN_CX_EX_FX_HX_NX_S3"
LETEstonian
LET_AN_CX_EX_FX_HX_NX_S3"
LFAPersian
LFA_AN_CX_EX_FX_HX_NO_S3"
LFA_RAFPersianAfghanistanLFA_RAF_AN_CX_EX_FX_HX_NO_S3Identical to LPS
LFIFinnish
LFI_AN_CX_EX_FX_HX_NX_S3"
LFOFaroese
LFO_AN_CX_EX_FX_HX_NX_S3"
LFRFrench
LFR_AN_CX_EX_FO_HX_NX_S3"
LGUGujarati
LGU_AN_CX_EX_FX_HX_NO_S3"
LHEHebrew
LHE_AN_CX_EX_FX_HX_NO_S3Identical to LROOT_NO
LHIHindi
LHI_AN_CX_EX_FX_HX_NO_S3"
LHI_KDIRECTHindi
LHI_KDIRECT_AN_CX_EX_FX_HX_NX_S3"
LHRCroatian
LHR_AN_CX_EX_FX_HX_NX_S3"
LHUHungarian
LHU_AN_CX_EX_FX_HX_NX_S3"
LISIcelandic
LIS_AN_CX_EX_FX_HX_NX_S3"
LITItalian
LIT_AN_CX_EX_FX_HX_NX_S3"
LJAJapanese
LJA_AN_CX_EX_FX_HO_NX_S3Treat hiragana to be equal to their katakana equivalents. To sort hiragana before katagana, set the strength level to 4.
LKKKazakh
LKK_AN_CX_EX_FX_HX_NO_S3"
LKLKalaallisut; Greenlandic
LKL_AN_CX_EX_FX_HX_NX_S3"
LKNKannada
LKN_AN_CX_EX_FX_HX_NO_S3Identical to LROOT_NO
LKOKorean
LKO_AN_CX_EX_FX_HX_NX_S3"
LLTLithuanian
LLT_AN_CX_EX_FX_HX_NX_S3"
LLVLatvian
LLV_AN_CX_EX_FX_HX_NX_S3"
LMKMacedonian
LMK_AN_CX_EX_FX_HX_NX_S3Identical to LRU
LMRMarathi
LMR_AN_CX_EX_FX_HX_NO_S3Identical to LROOT_NO
LMTMaltese
LMT_AN_CU_EX_FX_HX_NX_S3"
LNBNorwegian Bokmål
LNB_AN_CX_EX_FX_HX_NX_S3"
LNNNorwegian Nynorsk
LNN_AN_CX_EX_FX_HX_NX_S3"
LOMOromo
LOM_AN_CX_EX_FX_HX_NX_S3"
LPAPanjabi; Punjabi
LPA_AN_CX_EX_FX_HX_NO_S3Identical to LROOT_NO
LPLPolish
LPL_AN_CX_EX_FX_HX_NX_S3"
LPSPushto
LPS_AN_CX_EX_FX_HX_NO_S3"
LRORomanian
LRO_AN_CX_EX_FX_HX_NX_S3"
LROOT

LROOT_AN_CX_EX_FX_HX_NX_S3Default UCA
LRURussian
LRU_AN_CX_EX_FX_HX_NX_S3"
LSHSerbo-Croatian
LSH_AN_CX_EX_FX_HX_NX_S3Identical to LHR
LSKSlovak
LSK_AN_CX_EX_FX_HX_NX_S3"
LSLSlovenian
LSL_AN_CX_EX_FX_HX_NX_S3"
LSQAlbanian
LSQ_AN_CX_EX_FX_HX_NX_S3"
LSRSerbian
LSR_AN_CX_EX_FX_HX_NX_S3Identical to LRU
LSVSwedish
LSV_AN_CX_EX_FX_HX_NX_S3"
LTATamil
LTA_AN_CX_EX_FX_HX_NO_S3Identical to LROOT_NO
LTETelugu
LTE_AN_CX_EX_FX_HX_NO_S3"
LTHThai
LTH_AN_CX_EX_FX_HX_NO_S3"
LTRTurkish
LTR_AN_CX_EX_FX_HX_NX_S3"
LUKUkrainian
LUK_AN_CX_EX_FX_HX_NX_S3"
LVIVietnamese
LVI_AN_CX_EX_FX_HX_NO_S3"
LZH_KPINYINChinese
LZH_KPINYIN_AN_CX_EX_FX_HX_NX_S3Simplified Chinese, Pinyin ordering
LZH_KGB2312HANChinese
LZH_KGB2312HAN_AN_CX_EX_FX_HX_NX_S3Simplified Chinese, GB2312 ordering
LZH_ZHANT_KSTROKEChinese
LZH_ZHANT_KSTROKE_AN_CX_EX_FX_HX_NX_S3Traditional Chinese, Stroke ordering
LZH_ZHANT_KBIG5HANChinese
LZH_ZHANT_KBIG5HAN_AN_CX_EX_FX_HX_NX_S3Traditional Chinese, Big5 ordering

Return to article