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;