4
echo "DROP TABLE lang;"
5
echo "CREATE TABLE lang (lang varchar(128), letters text character set utf8);"
9
Greenlandic ÁÂÃÊÍÎÔÚÛáâãêíîôúûĨĩĸŨũ
10
#Use of these letters was abolished in a spelling reform in 1973:
11
#Greenlandic ÅÆØåæø
12
#Characters not found in the UCS:
13
# K LATIN CAPITAL LETTER KRA
14
#############################################################
15
#Basque ÑÜñüŔŕ
16
#Characters not found in the UCS:
17
# D LATIN CAPITAL LETTER D WITH MACRON
18
# d LATIN SMALL LETTER D WITH MACRON
19
# L LATIN CAPITAL LETTER L WITH MACRON
20
# l LATIN SMALL LETTER L WITH MACRON
21
# T LATIN CAPITAL LETTER T WITH MACRON
22
# t LATIN SMALL LETTER T WITH MACRON
23
#############################################################
24
#Maltese #ÀÁÂÈÉÊÌÍÎÒÓÔÙÚÛ#àáâèéêìíîòÓôùúû#ĊċĠġĦħŻżʼ
25
#BosnianCyr ЂЈЉЊЋЏАБВГДЕЖЗИКЛМНОПРСТУФХЦЧШабвгдежзиклмнопрстуфхцчшђјљњћџ
27
#Scots1 ƷȜȝʒ
28
###########################################
29
#### Hiragana 3040-309F
30
Hiragana ぁあぃいぅうぇえぉおかがきぎくぐけげこごさざしじすずせぜそぞただちぢっつづてでとどなにぬねのはばぱひびぴふぶぷへべぺほぼぽまみむめもゃやゅゆょよらりるれろゎわゐゑをん
31
Hiragana1 ゔ゙゚
32
Hiragana2 ゛゜ゝゞ
33
#### Katakana 30A0-30FF
34
Katakana ァアィイゥウェエォオカガキギクグケゲコゴサザシジスズセゼソゾタダチヂッツヅテデトドナニヌネノハバパヒビピフブプヘベペホボポマミムメモャヤュユョヨラリルレロヮワヰヱヲンヴヵヶ
35
Katakana1 ヷヸヹヺ
36
Katakana2 ・ーヽヾ
37
############################################
38
Albanian ÂÇËâçë
39
Bosnian ĆćČčĐ𩹮ž
40
Breton ÂÊÑÙÜâêñùü
41
Catalan ÀÇÈÉÍÏÒÓÚÜàçèéíïòóúü
42
#Catalan1 ·Ŀŀ
43
Croatian ĆćČčĐ𩹮ž
44
CroatianLig DZDzdzDŽDždžLJLjljNJNjnj
45
Czech ÁÉÍÓÚÝáéíóúýČčĎďĚěŇňŘřŠšŤťŮůŽž
46
Danish ÁÄÅÆÉÓÖØÜáäåæéóöøü
47
Dutch ÀÂÄÆÇÈÉÊËÎÏÑÒÓÔÖÙÚÛÜàâäæçèéêëîïñòóôöùúûü
48
Esperanto ĈĉĜĝĤĥĴĵŜŝŬŭ
49
Estonian ÄÕÖÜäõöüŠšŽž
50
Faroese ÅÆÐÓÖØÚÝåæðóöøúý
51
Finnish ÄÅÖÜäåöü
52
#Finnish1 ŠšŽž
53
French(limited) ÀÂÆÇÈÉÊËÎÏÑÔÙÛàâæçèéêëîïñôùûÿ
54
French ŒœŸ
55
German ÄÖÜßäöü
56
Hungarian ÁÉÍÓÖÚÜáéíóöúüŐőŰű
57
Icelandic ÁÆÉÍÐÓÖÚÝÞáæéíðóöúýþ
58
Italian ÀÈÉÌÍÏÒÓÙÚàèéìíïòóùú
60
Latvian ĀāČčĒēĢģĪīĶķĻļŅņŠšŪūŽž
61
Lithuanian ĄąČčĖėĘęĮįŠšŪūŲųŽž
62
Norwegian ÅÆØåæø
63
Polish ÓóĄąĆćĘꣳŃńŚśŹźŻż
64
Portuguese ÀÁÂÃÇÉÊÍÓÔÕÚÜàáâãçéêíóôõúü
65
#http://en.wikipedia.org/wiki/Special_Romanian_Unicode_characters
66
Romanian ÂÎâîĂăȘșȚț
67
Romanian(ErrorST) ÂÎâîĂ㪺Ţţ
68
Slovak ÁÄÉÍÓÔÚÝáäéíóôúýČčĎďĹ弾ŇňŔ੹ŤťŽž
69
Slovene Č芚Žž
70
Sorbian-Lower ĆćČčĚ죳ŃńŘřŚśŠšŹźŽž
71
Sorbian-Upper ÓóĆćČčĚ죳ŃńŘřŠšŽž
72
Spanish ÁÉÍÑÓÚÜáéíñóúü
73
Swedish ÄÅÖäåö
74
Turkish ÂÇÖÛÜâçöûüĞğİı
75
Welsh ÀÁÂÄÈÉÊËÌÍÎÏÒÓÔÖÙÚÛÜÝàáâäèéêëìíîïòóôöùúûüýÿŴŵŶŷŸẀẁẂẃẄẅỲỳ
76
##################################
77
Belarusian ЁІЎАБВГДЕЖЗИЙКЛМНОПРСТУФХЦЧШЩЪЫЬЭЮЯабвгдежзийклмнопрстуфхцчшщъыьэюяёіў
78
Bulgarian АБВГДЕЖЗИЙКЛМНОПРСТУФХЦЧШЩЪЬЮЯабвгдежзийклмнопрстуфхцчшщъьюя
79
Bulgarian1 ЀҭѐѝѢѣѪѫ
80
Macedonian ЃЅЈЉЊЌЏАБВГДЕЖЗИКЛМНОПРСТУФХЦЧШабвгдежзиклмнопрстуфхцчшѓѕјљњќџ
81
Russian ЁАБВГДЕЖЗИЙКЛМНОПРСТУФХЦЧШЩЪЫЬЭЮЯабвгдежзийклмнопрстуфхцчшщъыьэюяё
82
RussianOLD ІіѢѣѲѳѴѵ
83
Serbian ЂЈЉЊЋЏАБВГДЕЖЗИКЛМНОПРСТУФХЦЧШабвгдежзиклмнопрстуфхцчшђјљњћџ
84
Ukrainian ЄІЇАБВГДЕЖЗИЙКЛМНОПРСТУФХЦЧШЩЬЭЮЯабвгдежзийклмнопрстуфхцчшщьэюяєіїҐґ
85
##################################
86
Armenian ԱԲԳԴԵԶԷԸԹԺԻԼԽԾԿՁՂՃՄՅՆՇՈՉՊՋՌՍՎՏՑՒՓՔՕՖ՛՜՝՞՟աբգդեֆ։
87
#Armenian1 ՚֊
88
#Characters not found in the UCS:
89
# ARMENIAN ETERNITY SIGN
91
GeorgianOld ႠႡႢႣႤႥႦႧႨႩႪႫႬႭႮႯႰႱႲႳႴႵႶႷႸႹႺႻႼႽႾႿჀჁჂჃჄჅ
92
Georgian აბგდევზთიკლმნოპჟრსტუფქღყშჩცძწჭხჯჰ
93
GeorgianArc ჱჲჳჴჵჶ
96
GreekExt1 ΄΅Ά·ΈΉΊ»Ό½ΎΏΐ
97
Greek ΑΒΓΔΕΖΗΘΙΚΛΜΝΞΟΠΡΣΤΥΦΧΨΩαβγδεζηθικλμνξοπρστυφχψω
98
GreekExt2 ΪΫάέήίΰϊϋόύώ
101
Hebrew אבגדהוזחטיךכלםמןנסעףפץצקרשת
102
##################################
223
################################
224
# 4 Gaelic-new-orthography
227
# 2 S&AACUTEmi-with-restrictions
229
# 1 Gaelic-old-and-new-orthographies
235
c=`echo $b | replace "&#x" "" ";" ""`
236
printf "INSERT INTO lang VALUES ('$a',_ucs2 X'$c');\n"
241
#SELECT * FROM lang WHERE CONVERT(letters USING latin1) NOT LIKE _binary'%?%';
242
#SELECT * FROM lang WHERE CONVERT(letters USING latin2) NOT LIKE _binary'%?%';
247
list="big5 dec8 cp850 hp8 koi8r latin1 latin2 swe7 ascii ujis sjis hebrew euckr koi8u gb2312 greek cp1250 gbk latin5 armscii8 cp866 keybcs2 macce macroman cp852 latin7 cp1251 cp1256 cp1257 geostd8"
251
echo "-----------------"
253
mysql -sss test << END
254
SELECT lang FROM lang WHERE CONVERT(letters USING $p) NOT LIKE _binary'%?%' ORDER BY lang;