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