3
=hѹ              #  @   s,  d Z ddddddddddddddd	dd
dddd	dd
dddd	dddddd	dddddd	dddddd	dddddd	dddddd	dddddd	dddddd	dddddd	dddddd	dddddd	dddddd	dddd dd	dddd!dd	dddd"d#d	d$d%dd$d#d	d$d%dd&d#d	d$d%dd'd#d	d$d%dd(d#d	d$d%dd)d*d	d)d+dd,d*d	d)d+dd-d.d	d-d/dd0d.d	d-d/dd1d2d3d1d4dd5d2d3d1d4dd6d7dd6d8dd9d7dd6d8dd:d;d	d:d<dd=d;d	d:d<dd>d?d	d>d@ddAd?d	d>d@ddBdCddBdDddEdCddBdDddFdGd	dFdHddIdGd	dFdHddJdKddJdLddMdKddJdLddNdOd	dNdPddQdOd	dNdPddRdSd	dRdTddUdSd	dRdTddVdSd	dRdTddWdSd	dRdTddXdSd	dRdTddYdZddYd[dd\dZddYd[dd]d^d	d]d_dd`d^d	d]d_ddadbd	dadcddddbd	dadcddedfd3dedgddhdfd3dedgddidfd3dedgddjdfd3dedgddkdfd3dedgddldfd3dedgddmdfd3dedgddndfd3dedgddodfd3dedgddpdfd3dedgddqdfd3dedgddrdfd3dedgddsdfd3dedgddtdfd3dedgddudfd3dedgddvdfd3dedgddwdfd3dedgddxdfd3dedgddydfd3dedgddzdfd3dedgdd{dfd3dedgdd|dfd3dedgdd}dfd3dedgdd~dfd3dedgdddfd3dedgdddfd3dedgdddfd3dedgdddfd3dedgdddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddd	dddddd	dddddd	dddddd	dddddd	dddddd	dddddd	dddddd	dddddd	dddddd	dddddd	dddddd	dddddd	dddddd	dddddd	dddddd	dddddd	dddddd	dddddd	dddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddd	dddddd	dddddd	dddddd	dddddd	dddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddd dddddddddddddddddddddddddddddddddddddddddddd	dddd	d
d	d	dddd
d	d	ddddddddddddddddd3dddddd3ddddddÐddddddÐddddddÐddddddÐddgddddÐddgddddÐddgddddÐddgdd ddÐddgdd!ddÐddgdd"ddÐddgdd#ddÐddgdd$ddÐddgdd%ddÐddgdd&ddÐddgdd'ddÐddgdd(ddÐddgdd)ddÐddgdd*ddÐddgdd+ddÐddgdd,ddÐddgdd-ddÐddgdd.ddÐddgdd/ddÐddgdd0ddÐddgdd1ddÐddgdd2ddÐddgdd3ddÐddgdd4ddÐddgdd5ddÐddgddddÐddgdd6ddÐddgdd7ddÐddgdd8ddÐddgdd9ddÐddgdd:ddÐddgdd;ddÐddgdd<ddÐddgdd=ddÐddgdd>ddÐddgdd?ddÐddgdd@ddÐddgddAddÐddgddBddÐddgddCddÐddgddDddÐddgddEddÐddgddFddÐddgddGddÐddgddHddÐddgddIddÐddgddJddÐddgddKddÐddgddLddÐddgddMddÐddgddNddÐddgddOddÐddgddPddÐddgddQddÐddgddRddÐddgddSddÐddgddTddÐddgddUddÐddgddVddÐddgddWddÐddgddXddÐddgddYddÐddgddZddÐddgdd[ddÐddgdd\ddÐddgdd]ddÐddgdd^ddÐddgdd_ddÐddgdd`ddÐddgddaddÐddgddbddÐddgddcddÐddgdddddÐddgddeddÐddgddfddÐddgddgddÐddgddhddÐddgddiddÐddgddjddÐddgddkddÐddgddlddÐddgddmddÐddgddnddÐddgddoddÐddgddpddÐddgddqddÐddgddrddÐddgddsddÐddgddtZduS (v  a  
-- reference SQL
set session group_concat_max_len=10240000;
SELECT 
    CONCAT('{',
            GROUP_CONCAT(CONCAT('"',
                        b.id,
                        '":{"COLLATION_NAME":"',
                        b.COLLATION_NAME,
                        '","CHARACTER_SET_NAME":"',
                        b.CHARACTER_SET_NAME,
                        '","MAXLEN":"',
                        a.MAXLEN,
                        '","DEFAULT_COLLATE_NAME":"',
                        a.DEFAULT_COLLATE_NAME,
                        '","DESCRIPTION":"',
                        a.DESCRIPTION,
                        '"}')),
            '}') AS pydict_charset
FROM
    information_schema.CHARACTER_SETS AS a
        JOIN
    information_schema.COLLATIONS AS b ON a.CHARACTER_SET_NAME = b.CHARACTER_SET_NAME;

-- result: 
COLLATIONS_DICT:{
	"1":{
		"COLLATION_NAME":"big5_chinese_ci",
		"CHARACTER_SET_NAME":"big5",
		"MAXLEN":"2",
		"DEFAULT_COLLATE_NAME":"big5_chinese_ci",
		"DESCRIPTION":"Big5 Traditional Chinese"
	}, ...
....
}
Zbig5_chinese_cibig52zBig5 Traditional Chinese)ZCOLLATION_NAMEZCHARACTER_SET_NAMEMAXLENZDEFAULT_COLLATE_NAMEZDESCRIPTIONZbig5_binZdec8_swedish_cidec81zDEC West EuropeanZdec8_binZcp850_general_cicp850zDOS West EuropeanZ	cp850_binZhp8_english_cihp8zHP West EuropeanZhp8_binZkoi8r_general_ciZkoi8rzKOI8-R Relcom RussianZ	koi8r_binZlatin1_german1_cilatin1Zlatin1_swedish_cizcp1252 West EuropeanZlatin1_danish_ciZlatin1_german2_ciZ
latin1_binZlatin1_general_ciZlatin1_general_csZlatin1_spanish_ciZlatin2_czech_cslatin2Zlatin2_general_cizISO 8859-2 Central EuropeanZlatin2_hungarian_ciZlatin2_croatian_ciZ
latin2_binZswe7_swedish_ciswe7z7bit SwedishZswe7_binZascii_general_ciasciizUS ASCIIZ	ascii_binZujis_japanese_ciujis3zEUC-JP JapaneseZujis_binZsjis_japanese_cisjiszShift-JIS JapaneseZsjis_binZhebrew_general_cihebrewzISO 8859-8 HebrewZ
hebrew_binZtis620_thai_citis620zTIS620 ThaiZ
tis620_binZeuckr_korean_cieuckrzEUC-KR KoreanZ	euckr_binZkoi8u_general_ciZkoi8uzKOI8-U UkrainianZ	koi8u_binZgb2312_chinese_cigb2312zGB2312 Simplified ChineseZ
gb2312_binZgreek_general_cigreekzISO 8859-7 GreekZ	greek_binZcp1250_general_cicp1250zWindows Central EuropeanZcp1250_czech_csZcp1250_croatian_ciZ
cp1250_binZcp1250_polish_ciZgbk_chinese_cigbkzGBK Simplified ChineseZgbk_binZlatin5_turkish_cilatin5zISO 8859-9 TurkishZ
latin5_binZarmscii8_general_ciarmscii8zARMSCII-8 ArmenianZarmscii8_binZutf8mb3_general_ciZutf8mb3zUTF-8 UnicodeZutf8mb3_tolower_ciZutf8mb3_binZutf8mb3_unicode_ciZutf8mb3_icelandic_ciZutf8mb3_latvian_ciZutf8mb3_romanian_ciZutf8mb3_slovenian_ciZutf8mb3_polish_ciZutf8mb3_estonian_ciZutf8mb3_spanish_ciZutf8mb3_swedish_ciZutf8mb3_turkish_ciZutf8mb3_czech_ciZutf8mb3_danish_ciZutf8mb3_lithuanian_ciZutf8mb3_slovak_ciZutf8mb3_spanish2_ciZutf8mb3_roman_ciZutf8mb3_persian_ciZutf8mb3_esperanto_ciZutf8mb3_hungarian_ciZutf8mb3_sinhala_ciZutf8mb3_german2_ciZutf8mb3_croatian_ciZutf8mb3_unicode_520_ciZutf8mb3_vietnamese_ciZutf8mb3_general_mysql500_ciZucs2_general_ciZucs2zUCS-2 UnicodeZucs2_binZucs2_unicode_ciZucs2_icelandic_ciZucs2_latvian_ciZucs2_romanian_ciZucs2_slovenian_ciZucs2_polish_ciZucs2_estonian_ciZucs2_spanish_ciZucs2_swedish_ciZucs2_turkish_ciZucs2_czech_ciZucs2_danish_ciZucs2_lithuanian_ciZucs2_slovak_ciZucs2_spanish2_ciZucs2_roman_ciZucs2_persian_ciZucs2_esperanto_ciZucs2_hungarian_ciZucs2_sinhala_ciZucs2_german2_ciZucs2_croatian_ciZucs2_unicode_520_ciZucs2_vietnamese_ciZucs2_general_mysql500_ciZcp866_general_cicp866zDOS RussianZ	cp866_binZkeybcs2_general_cikeybcs2zDOS Kamenicky Czech-SlovakZkeybcs2_binZmacce_general_ciZmaccezMac Central EuropeanZ	macce_binZmacroman_general_cimacromanzMac West EuropeanZmacroman_binZcp852_general_cicp852zDOS Central EuropeanZ	cp852_binZlatin7_estonian_cslatin7Zlatin7_general_cizISO 8859-13 BalticZlatin7_general_csZ
latin7_binZcp1251_bulgarian_cicp1251Zcp1251_general_cizWindows CyrillicZcp1251_ukrainian_ciZ
cp1251_binZcp1251_general_csZutf16_general_ciutf164zUTF-16 UnicodeZ	utf16_binZutf16_unicode_ciZutf16_icelandic_ciZutf16_latvian_ciZutf16_romanian_ciZutf16_slovenian_ciZutf16_polish_ciZutf16_estonian_ciZutf16_spanish_ciZutf16_swedish_ciZutf16_turkish_ciZutf16_czech_ciZutf16_danish_ciZutf16_lithuanian_ciZutf16_slovak_ciZutf16_spanish2_ciZutf16_roman_ciZutf16_persian_ciZutf16_esperanto_ciZutf16_hungarian_ciZutf16_sinhala_ciZutf16_german2_ciZutf16_croatian_ciZutf16_unicode_520_ciZutf16_vietnamese_ciZutf16le_general_ciZutf16lezUTF-16LE UnicodeZutf16le_binZcp1256_general_cicp1256zWindows ArabicZ
cp1256_binZcp1257_lithuanian_cicp1257Zcp1257_general_cizWindows BalticZ
cp1257_binZutf32_general_ciutf32zUTF-32 UnicodeZ	utf32_binZutf32_unicode_ciZutf32_icelandic_ciZutf32_latvian_ciZutf32_romanian_ciZutf32_slovenian_ciZutf32_polish_ciZutf32_estonian_ciZutf32_spanish_ciZutf32_swedish_ciZutf32_turkish_ciZutf32_czech_ciZutf32_danish_ciZutf32_lithuanian_ciZutf32_slovak_ciZutf32_spanish2_ciZutf32_roman_ciZutf32_persian_ciZutf32_esperanto_ciZutf32_hungarian_ciZutf32_sinhala_ciZutf32_german2_ciZutf32_croatian_ciZutf32_unicode_520_ciZutf32_vietnamese_cibinaryzBinary pseudo charsetZgeostd8_general_cigeostd8zGEOSTD8 GeorgianZgeostd8_binZcp932_japanese_cicp932zSJIS for Windows JapaneseZ	cp932_binZeucjpms_japanese_ciZeucjpmszUJIS for Windows JapaneseZeucjpms_binZgb18030_chinese_cigb18030zChina National Standard GB18030Zgb18030_binZgb18030_unicode_520_ciZutf8mb4_general_ciZutf8mb4Zutf8mb4_0900_ai_ciZutf8mb4_binZutf8mb4_unicode_ciZutf8mb4_icelandic_ciZutf8mb4_latvian_ciZutf8mb4_romanian_ciZutf8mb4_slovenian_ciZutf8mb4_polish_ciZutf8mb4_estonian_ciZutf8mb4_spanish_ciZutf8mb4_swedish_ciZutf8mb4_turkish_ciZutf8mb4_czech_ciZutf8mb4_danish_ciZutf8mb4_lithuanian_ciZutf8mb4_slovak_ciZutf8mb4_spanish2_ciZutf8mb4_roman_ciZutf8mb4_persian_ciZutf8mb4_esperanto_ciZutf8mb4_hungarian_ciZutf8mb4_sinhala_ciZutf8mb4_german2_ciZutf8mb4_croatian_ciZutf8mb4_unicode_520_ciZutf8mb4_vietnamese_ciZutf8mb4_de_pb_0900_ai_ciZutf8mb4_is_0900_ai_ciZutf8mb4_lv_0900_ai_ciZutf8mb4_ro_0900_ai_ciZutf8mb4_sl_0900_ai_ciZutf8mb4_pl_0900_ai_ciZutf8mb4_et_0900_ai_ciZutf8mb4_es_0900_ai_ciZutf8mb4_sv_0900_ai_ciZutf8mb4_tr_0900_ai_ciZutf8mb4_cs_0900_ai_ciZutf8mb4_da_0900_ai_ciZutf8mb4_lt_0900_ai_ciZutf8mb4_sk_0900_ai_ciZutf8mb4_es_trad_0900_ai_ciZutf8mb4_la_0900_ai_ciZutf8mb4_eo_0900_ai_ciZutf8mb4_hu_0900_ai_ciZutf8mb4_hr_0900_ai_ciZutf8mb4_vi_0900_ai_ciZutf8mb4_0900_as_csZutf8mb4_de_pb_0900_as_csZutf8mb4_is_0900_as_csZutf8mb4_lv_0900_as_csZutf8mb4_ro_0900_as_csZutf8mb4_sl_0900_as_csZutf8mb4_pl_0900_as_csZutf8mb4_et_0900_as_csZutf8mb4_es_0900_as_csZutf8mb4_sv_0900_as_csZutf8mb4_tr_0900_as_csZutf8mb4_cs_0900_as_csZutf8mb4_da_0900_as_csZutf8mb4_lt_0900_as_csZutf8mb4_sk_0900_as_csZutf8mb4_es_trad_0900_as_csZutf8mb4_la_0900_as_csZutf8mb4_eo_0900_as_csZutf8mb4_hu_0900_as_csZutf8mb4_hr_0900_as_csZutf8mb4_vi_0900_as_csZutf8mb4_ja_0900_as_csZutf8mb4_ja_0900_as_cs_ksZutf8mb4_0900_as_ciZutf8mb4_ru_0900_ai_ciZutf8mb4_ru_0900_as_csZutf8mb4_zh_0900_as_csZutf8mb4_0900_binZutf8mb4_nb_0900_ai_ciZutf8mb4_nb_0900_as_csZutf8mb4_nn_0900_ai_ciZutf8mb4_nn_0900_as_csZutf8mb4_sr_latn_0900_ai_ciZutf8mb4_sr_latn_0900_as_csZutf8mb4_bs_0900_ai_ciZutf8mb4_bs_0900_as_csZutf8mb4_bg_0900_ai_ciZutf8mb4_bg_0900_as_csZutf8mb4_gl_0900_ai_ciZutf8mb4_gl_0900_as_csZutf8mb4_mn_cyrl_0900_ai_ciZutf8mb4_mn_cyrl_0900_as_cs(  r   Z84r   Z69r   Z806Z727Z7458Z15Z31Z47Z48Z49Z94r   9Z21Z27Z77Z10Z82Z11Z65Z12Z91Z13Z88Z16Z71Z18Z89Z19Z85Z22Z75Z24Z86Z25Z70Z26Z34Z44Z66Z99Z28Z87Z30Z78Z32Z64Z33Z76Z83Z192Z193Z194Z195Z196Z197Z198Z199Z200Z201Z202Z203Z204Z205Z206Z207Z208Z209Z210Z211Z212Z213Z214Z215Z223Z35Z90Z128Z129Z130Z131Z132Z133Z134Z135Z136Z137Z138Z139Z140Z141Z142Z143Z144Z145Z146Z147Z148Z149Z150Z151Z159Z36Z68Z37Z73Z38Z43Z39Z53Z40Z81Z20Z41Z42Z79Z14Z23Z50Z51Z52Z54Z55Z101Z102Z103Z104Z105Z106Z107Z108Z109Z110Z111Z112Z113Z114Z115Z116Z117Z118Z119Z120Z121Z122Z123Z124Z56Z62Z57Z67Z29Z58Z59Z60Z61Z160Z161Z162Z163Z164Z165Z166Z167Z168Z169Z170Z171Z172Z173Z174Z175Z176Z177Z178Z179Z180Z181Z182Z183Z63Z92Z93Z95Z96Z97Z98Z248Z249Z250Z45Z46Z224Z225Z226Z227Z228Z229Z230Z231Z232Z233Z234Z235Z236Z237Z238Z239Z240Z241Z242Z243Z244Z245Z246Z247Z255Z256Z257Z258Z259Z260Z261Z262Z263Z264Z265Z266Z267Z268Z269Z270Z271273Z274Z275Z277Z278Z279Z280Z281Z282Z283Z284Z285Z286Z287Z288Z289Z290Z291Z292Z293Z294Z296Z297Z298Z300Z303Z304Z305Z306Z307Z308Z309Z310Z311Z312Z313Z314Z315Z316Z317Z318Z319Z320Z321Z322Z323N)__doc__COLLATIONS_DICT r/   r/   ;/root/work/ibd2sql-ibd2sql-v2.x/ibd2sql/utils/collations.py<module>$   s   