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