1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
|
SET names utf8;
select * from information_schema.locales;
ID NAME DESCRIPTION MAX_MONTH_NAME_LENGTH MAX_DAY_NAME_LENGTH DECIMAL_POINT THOUSAND_SEP ERROR_MESSAGE_LANGUAGE
0 en_US English - United States 9 9 . , english
1 en_GB English - United Kingdom 9 9 . , english
2 ja_JP Japanese - Japan 3 3 . , japanese
3 sv_SE Swedish - Sweden 9 7 , swedish
4 de_DE German - Germany 9 10 , . german
5 fr_FR French - France 9 8 , french
6 ar_AE Arabic - United Arab Emirates 6 8 . , english
7 ar_BH Arabic - Bahrain 6 8 . , english
8 ar_JO Arabic - Jordan 12 8 . , english
9 ar_SA Arabic - Saudi Arabia 12 8 . english
10 ar_SY Arabic - Syria 12 8 . , english
11 be_BY Belarusian - Belarus 10 10 , . english
12 bg_BG Bulgarian - Bulgaria 9 10 , english
13 ca_ES Catalan - Catalan 8 9 , english
14 cs_CZ Czech - Czech Republic 8 7 , czech
15 da_DK Danish - Denmark 9 7 , . danish
16 de_AT German - Austria 9 10 , german
17 es_ES Spanish - Spain 10 9 , . spanish
18 et_EE Estonian - Estonia 9 9 , estonian
19 eu_ES Basque - Basque 9 10 , english
20 fi_FI Finnish - Finland 9 11 , english
21 fo_FO Faroese - Faroe Islands 9 12 , . english
22 gl_ES Galician - Galician 8 8 , english
23 gu_IN Gujarati - India 10 8 . , english
24 he_IL Hebrew - Israel 7 5 . , english
25 hi_IN Hindi - India 7 9 . , hindi
26 hr_HR Croatian - Croatia 8 11 , english
27 hu_HU Hungarian - Hungary 10 9 , . hungarian
28 id_ID Indonesian - Indonesia 9 6 , . english
29 is_IS Icelandic - Iceland 9 12 , . english
30 it_CH Italian - Switzerland 9 9 , ' italian
31 ko_KR Korean - Korea 3 3 . , korean
32 lt_LT Lithuanian - Lithuania 9 14 , . english
33 lv_LV Latvian - Latvia 10 11 , english
34 mk_MK Macedonian - FYROM 9 10 , english
35 mn_MN Mongolia - Mongolian 18 6 , . english
36 ms_MY Malay - Malaysia 9 6 . , english
37 nb_NO Norwegian(Bokml) - Norway 9 7 , . norwegian
38 nl_NL Dutch - The Netherlands 9 9 , dutch
39 pl_PL Polish - Poland 11 12 , polish
40 pt_BR Portuguese - Brazil 9 7 , portuguese
41 pt_PT Portuguese - Portugal 9 7 , portuguese
42 ro_RO Romanian - Romania 10 8 , . romanian
43 ru_RU Russian - Russia 8 11 , russian
44 ru_UA Russian - Ukraine 8 11 , . russian
45 sk_SK Slovak - Slovakia 9 8 , slovak
46 sl_SI Slovenian - Slovenia 9 10 , english
47 sq_AL Albanian - Albania 7 10 , . english
48 sr_RS Serbian - Serbia 9 10 . serbian
49 ta_IN Tamil - India 10 8 . , english
50 te_IN Telugu - India 10 9 . , english
51 th_TH Thai - Thailand 10 8 . , english
52 tr_TR Turkish - Türkiye 7 9 , . english
53 uk_UA Ukrainian - Ukraine 8 9 , . ukrainian
54 ur_PK Urdu - Pakistan 6 6 . , english
55 vi_VN Vietnamese - Vietnam 16 11 , . english
56 zh_CN Chinese - Peoples Republic of China 3 3 . , chinese
57 zh_TW Chinese - Taiwan 3 2 . , english
58 ar_DZ Arabic - Algeria 6 8 . , english
59 ar_EG Arabic - Egypt 6 8 . , english
60 ar_IN Arabic - Iran 6 8 . , english
61 ar_IQ Arabic - Iraq 6 8 . , english
62 ar_KW Arabic - Kuwait 6 8 . , english
63 ar_LB Arabic - Lebanon 12 8 . , english
64 ar_LY Arabic - Libya 6 8 . , english
65 ar_MA Arabic - Morocco 6 8 . , english
66 ar_OM Arabic - Oman 6 8 . , english
67 ar_QA Arabic - Qatar 6 8 . , english
68 ar_SD Arabic - Sudan 6 8 . , english
69 ar_TN Arabic - Tunisia 6 8 . , english
70 ar_YE Arabic - Yemen 6 8 . , english
71 de_BE German - Belgium 9 10 , . german
72 de_CH German - Switzerland 9 10 . ' german
73 de_LU German - Luxembourg 9 10 , . german
74 en_AU English - Australia 9 9 . , english
75 en_CA English - Canada 9 9 . , english
76 en_IN English - India 9 9 . , english
77 en_NZ English - New Zealand 9 9 . , english
78 en_PH English - Philippines 9 9 . , english
79 en_ZA English - South Africa 9 9 . , english
80 en_ZW English - Zimbabwe 9 9 . , english
81 es_AR Spanish - Argentina 10 9 , . spanish
82 es_BO Spanish - Bolivia 10 9 , . spanish
83 es_CL Spanish - Chile 10 9 , . spanish
84 es_CO Spanish - Columbia 10 9 , . spanish
85 es_CR Spanish - Costa Rica 10 9 , spanish
86 es_DO Spanish - Dominican Republic 10 9 . , spanish
87 es_EC Spanish - Ecuador 10 9 , . spanish
88 es_GT Spanish - Guatemala 10 9 . , spanish
89 es_HN Spanish - Honduras 10 9 . , spanish
90 es_MX Spanish - Mexico 10 9 . , spanish
91 es_NI Spanish - Nicaragua 10 9 . , spanish
92 es_PA Spanish - Panama 10 9 . , spanish
93 es_PE Spanish - Peru 10 9 . , spanish
94 es_PR Spanish - Puerto Rico 10 9 . , spanish
95 es_PY Spanish - Paraguay 10 9 , . spanish
96 es_SV Spanish - El Salvador 10 9 . , spanish
97 es_US Spanish - United States 10 9 . , spanish
98 es_UY Spanish - Uruguay 10 9 , . spanish
99 es_VE Spanish - Venezuela 10 9 , . spanish
100 fr_BE French - Belgium 9 8 , . french
101 fr_CA French - Canada 9 8 , french
102 fr_CH French - Switzerland 9 8 , french
103 fr_LU French - Luxembourg 9 8 , french
104 it_IT Italian - Italy 9 9 , italian
105 nl_BE Dutch - Belgium 9 9 , . dutch
106 no_NO Norwegian - Norway 9 7 , . norwegian
107 sv_FI Swedish - Finland 9 7 , swedish
108 zh_HK Chinese - Hong Kong SAR 3 3 . , english
109 el_GR Greek - Greece 11 9 , . greek
110 rm_CH Romansh - Switzerland 9 9 , ' english
111 ka_GE Georgian - Georgia 10 9 , georgian
show locales;
Id Name Description Error_Message_Language
0 en_US English - United States english
1 en_GB English - United Kingdom english
2 ja_JP Japanese - Japan japanese
3 sv_SE Swedish - Sweden swedish
4 de_DE German - Germany german
5 fr_FR French - France french
6 ar_AE Arabic - United Arab Emirates english
7 ar_BH Arabic - Bahrain english
8 ar_JO Arabic - Jordan english
9 ar_SA Arabic - Saudi Arabia english
10 ar_SY Arabic - Syria english
11 be_BY Belarusian - Belarus english
12 bg_BG Bulgarian - Bulgaria english
13 ca_ES Catalan - Catalan english
14 cs_CZ Czech - Czech Republic czech
15 da_DK Danish - Denmark danish
16 de_AT German - Austria german
17 es_ES Spanish - Spain spanish
18 et_EE Estonian - Estonia estonian
19 eu_ES Basque - Basque english
20 fi_FI Finnish - Finland english
21 fo_FO Faroese - Faroe Islands english
22 gl_ES Galician - Galician english
23 gu_IN Gujarati - India english
24 he_IL Hebrew - Israel english
25 hi_IN Hindi - India hindi
26 hr_HR Croatian - Croatia english
27 hu_HU Hungarian - Hungary hungarian
28 id_ID Indonesian - Indonesia english
29 is_IS Icelandic - Iceland english
30 it_CH Italian - Switzerland italian
31 ko_KR Korean - Korea korean
32 lt_LT Lithuanian - Lithuania english
33 lv_LV Latvian - Latvia english
34 mk_MK Macedonian - FYROM english
35 mn_MN Mongolia - Mongolian english
36 ms_MY Malay - Malaysia english
37 nb_NO Norwegian(Bokml) - Norway norwegian
38 nl_NL Dutch - The Netherlands dutch
39 pl_PL Polish - Poland polish
40 pt_BR Portuguese - Brazil portuguese
41 pt_PT Portuguese - Portugal portuguese
42 ro_RO Romanian - Romania romanian
43 ru_RU Russian - Russia russian
44 ru_UA Russian - Ukraine russian
45 sk_SK Slovak - Slovakia slovak
46 sl_SI Slovenian - Slovenia english
47 sq_AL Albanian - Albania english
48 sr_RS Serbian - Serbia serbian
49 ta_IN Tamil - India english
50 te_IN Telugu - India english
51 th_TH Thai - Thailand english
52 tr_TR Turkish - Türkiye english
53 uk_UA Ukrainian - Ukraine ukrainian
54 ur_PK Urdu - Pakistan english
55 vi_VN Vietnamese - Vietnam english
56 zh_CN Chinese - Peoples Republic of China chinese
57 zh_TW Chinese - Taiwan english
58 ar_DZ Arabic - Algeria english
59 ar_EG Arabic - Egypt english
60 ar_IN Arabic - Iran english
61 ar_IQ Arabic - Iraq english
62 ar_KW Arabic - Kuwait english
63 ar_LB Arabic - Lebanon english
64 ar_LY Arabic - Libya english
65 ar_MA Arabic - Morocco english
66 ar_OM Arabic - Oman english
67 ar_QA Arabic - Qatar english
68 ar_SD Arabic - Sudan english
69 ar_TN Arabic - Tunisia english
70 ar_YE Arabic - Yemen english
71 de_BE German - Belgium german
72 de_CH German - Switzerland german
73 de_LU German - Luxembourg german
74 en_AU English - Australia english
75 en_CA English - Canada english
76 en_IN English - India english
77 en_NZ English - New Zealand english
78 en_PH English - Philippines english
79 en_ZA English - South Africa english
80 en_ZW English - Zimbabwe english
81 es_AR Spanish - Argentina spanish
82 es_BO Spanish - Bolivia spanish
83 es_CL Spanish - Chile spanish
84 es_CO Spanish - Columbia spanish
85 es_CR Spanish - Costa Rica spanish
86 es_DO Spanish - Dominican Republic spanish
87 es_EC Spanish - Ecuador spanish
88 es_GT Spanish - Guatemala spanish
89 es_HN Spanish - Honduras spanish
90 es_MX Spanish - Mexico spanish
91 es_NI Spanish - Nicaragua spanish
92 es_PA Spanish - Panama spanish
93 es_PE Spanish - Peru spanish
94 es_PR Spanish - Puerto Rico spanish
95 es_PY Spanish - Paraguay spanish
96 es_SV Spanish - El Salvador spanish
97 es_US Spanish - United States spanish
98 es_UY Spanish - Uruguay spanish
99 es_VE Spanish - Venezuela spanish
100 fr_BE French - Belgium french
101 fr_CA French - Canada french
102 fr_CH French - Switzerland french
103 fr_LU French - Luxembourg french
104 it_IT Italian - Italy italian
105 nl_BE Dutch - Belgium dutch
106 no_NO Norwegian - Norway norwegian
107 sv_FI Swedish - Finland swedish
108 zh_HK Chinese - Hong Kong SAR english
109 el_GR Greek - Greece greek
110 rm_CH Romansh - Switzerland english
111 ka_GE Georgian - Georgia georgian
show locales like '%spanish%';
ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'like '%spanish%'' at line 1
show locales where description like '%spanish%';
Id Name Description Error_Message_Language
17 es_ES Spanish - Spain spanish
81 es_AR Spanish - Argentina spanish
82 es_BO Spanish - Bolivia spanish
83 es_CL Spanish - Chile spanish
84 es_CO Spanish - Columbia spanish
85 es_CR Spanish - Costa Rica spanish
86 es_DO Spanish - Dominican Republic spanish
87 es_EC Spanish - Ecuador spanish
88 es_GT Spanish - Guatemala spanish
89 es_HN Spanish - Honduras spanish
90 es_MX Spanish - Mexico spanish
91 es_NI Spanish - Nicaragua spanish
92 es_PA Spanish - Panama spanish
93 es_PE Spanish - Peru spanish
94 es_PR Spanish - Puerto Rico spanish
95 es_PY Spanish - Paraguay spanish
96 es_SV Spanish - El Salvador spanish
97 es_US Spanish - United States spanish
98 es_UY Spanish - Uruguay spanish
99 es_VE Spanish - Venezuela spanish
flush locales;
ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'locales' at line 1
|