Details
-
Task
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
-
None
-
None
Description
Hi guys, today i don't know what locales are supported by mysql/mariadb
i attached a patch that show locales in server (mariadb 10.0.2)
thanks guys!
EXAMPLE:
SELECT ID, NAME, DESCRIPTION, MAX_MONTH_NAME_LENGTH, MAX_DAY_NAME_LENGTH, DECIMAL_POINT, THOUSAND_SEP FROM information_schema.LOCALES ORDER BY NAME ASC;
|
ID | NAME | DESCRIPTION | MAX_MONTH_NAME_LENGTH | MAX_DAY_NAME_LENGTH | DECIMAL_POINT | THOUSAND_SEP |
---|---|---|---|---|---|---|
6 | ar_AE | Arabic - United Arab Emirates | 6 | 8 | . | , |
7 | ar_BH | Arabic - Bahrain | 6 | 8 | . | , |
58 | ar_DZ | Arabic - Algeria | 6 | 8 | . | , |
59 | ar_EG | Arabic - Egypt | 6 | 8 | . | , |
60 | ar_IN | Arabic - Iran | 6 | 8 | . | , |
61 | ar_IQ | Arabic - Iraq | 6 | 8 | . | , |
8 | ar_JO | Arabic - Jordan | 12 | 8 | . | , |
62 | ar_KW | Arabic - Kuwait | 6 | 8 | . | , |
63 | ar_LB | Arabic - Lebanon | 12 | 8 | . | , |
64 | ar_LY | Arabic - Libya | 6 | 8 | . | , |
65 | ar_MA | Arabic - Morocco | 6 | 8 | . | , |
66 | ar_OM | Arabic - Oman | 6 | 8 | . | , |
67 | ar_QA | Arabic - Qatar | 6 | 8 | . | , |
9 | ar_SA | Arabic - Saudi Arabia | 12 | 8 | . | |
68 | ar_SD | Arabic - Sudan | 6 | 8 | . | , |
10 | ar_SY | Arabic - Syria | 12 | 8 | . | , |
69 | ar_TN | Arabic - Tunisia | 6 | 8 | . | , |
70 | ar_YE | Arabic - Yemen | 6 | 8 | . | , |
11 | be_BY | Belarusian - Belarus | 10 | 10 | , | . |
12 | bg_BG | Bulgarian - Bulgaria | 9 | 10 | , | |
13 | ca_ES | Catalan - Catalan | 8 | 9 | , | |
14 | cs_CZ | Czech - Czech Republic | 8 | 7 | , | |
15 | da_DK | Danish - Denmark | 9 | 7 | , | . |
16 | de_AT | German - Austria | 9 | 10 | , | |
71 | de_BE | German - Belgium | 9 | 10 | , | . |
72 | de_CH | German - Switzerland | 9 | 10 | . | ' |
4 | de_DE | German - Germany | 9 | 10 | , | . |
73 | de_LU | German - Luxembourg | 9 | 10 | , | . |
109 | el_GR | Greek - Greece | 11 | 9 | , | . |
74 | en_AU | English - Australia | 9 | 9 | . | , |
75 | en_CA | English - Canada | 9 | 9 | . | , |
1 | en_GB | English - United Kingdom | 9 | 9 | . | , |
76 | en_IN | English - India | 9 | 9 | . | , |
77 | en_NZ | English - New Zealand | 9 | 9 | . | , |
78 | en_PH | English - Philippines | 9 | 9 | . | , |
0 | en_US | English - United States | 9 | 9 | . | , |
79 | en_ZA | English - South Africa | 9 | 9 | . | , |
80 | en_ZW | English - Zimbabwe | 9 | 9 | . | , |
81 | es_AR | Spanish - Argentina | 10 | 9 | , | . |
82 | es_BO | Spanish - Bolivia | 10 | 9 | , | |
83 | es_CL | Spanish - Chile | 10 | 9 | , | |
84 | es_CO | Spanish - Columbia | 10 | 9 | , | |
85 | es_CR | Spanish - Costa Rica | 10 | 9 | . | |
86 | es_DO | Spanish - Dominican Republic | 10 | 9 | . | |
87 | es_EC | Spanish - Ecuador | 10 | 9 | , | |
17 | es_ES | Spanish - Spain | 10 | 9 | , | |
88 | es_GT | Spanish - Guatemala | 10 | 9 | . | |
89 | es_HN | Spanish - Honduras | 10 | 9 | . | |
90 | es_MX | Spanish - Mexico | 10 | 9 | . | |
91 | es_NI | Spanish - Nicaragua | 10 | 9 | . | |
92 | es_PA | Spanish - Panama | 10 | 9 | . | |
93 | es_PE | Spanish - Peru | 10 | 9 | . | |
94 | es_PR | Spanish - Puerto Rico | 10 | 9 | . | |
95 | es_PY | Spanish - Paraguay | 10 | 9 | , | |
96 | es_SV | Spanish - El Salvador | 10 | 9 | . | |
97 | es_US | Spanish - United States | 10 | 9 | . | , |
98 | es_UY | Spanish - Uruguay | 10 | 9 | , | |
99 | es_VE | Spanish - Venezuela | 10 | 9 | , | |
18 | et_EE | Estonian - Estonia | 9 | 9 | , | |
19 | eu_ES | Basque - Basque | 9 | 10 | , | |
20 | fi_FI | Finnish - Finland | 9 | 11 | , | |
21 | fo_FO | Faroese - Faroe Islands | 9 | 12 | , | . |
100 | fr_BE | French - Belgium | 9 | 8 | , | . |
101 | fr_CA | French - Canada | 9 | 8 | , | |
102 | fr_CH | French - Switzerland | 9 | 8 | , | |
5 | fr_FR | French - France | 9 | 8 | , | |
103 | fr_LU | French - Luxembourg | 9 | 8 | , | |
22 | gl_ES | Galician - Galician | 8 | 8 | , | |
23 | gu_IN | Gujarati - India | 10 | 8 | . | , |
24 | he_IL | Hebrew - Israel | 7 | 5 | . | , |
25 | hi_IN | Hindi - India | 7 | 9 | . | , |
26 | hr_HR | Croatian - Croatia | 8 | 11 | , | |
27 | hu_HU | Hungarian - Hungary | 10 | 9 | , | . |
28 | id_ID | Indonesian - Indonesia | 9 | 6 | , | . |
29 | is_IS | Icelandic - Iceland | 9 | 12 | , | . |
30 | it_CH | Italian - Switzerland | 9 | 9 | , | ' |
104 | it_IT | Italian - Italy | 9 | 9 | , | |
2 | ja_JP | Japanese - Japan | 3 | 3 | . | , |
31 | ko_KR | Korean - Korea | 3 | 3 | . | , |
32 | lt_LT | Lithuanian - Lithuania | 9 | 14 | , | . |
33 | lv_LV | Latvian - Latvia | 10 | 11 | , | |
34 | mk_MK | Macedonian - FYROM | 9 | 10 | , | |
35 | mn_MN | Mongolia - Mongolian | 18 | 6 | , | . |
36 | ms_MY | Malay - Malaysia | 9 | 6 | . | , |
37 | nb_NO | Norwegian(Bokml) - Norway | 9 | 7 | , | . |
105 | nl_BE | Dutch - Belgium | 9 | 9 | , | . |
38 | nl_NL | Dutch - The Netherlands | 9 | 9 | , | |
106 | no_NO | Norwegian - Norway | 9 | 7 | , | . |
39 | pl_PL | Polish - Poland | 11 | 12 | , | |
40 | pt_BR | Portugese - Brazil | 9 | 7 | , | |
41 | pt_PT | Portugese - Portugal | 9 | 7 | , | |
42 | ro_RO | Romanian - Romania | 10 | 8 | , | . |
43 | ru_RU | Russian - Russia | 8 | 11 | , | |
44 | ru_UA | Russian - Ukraine | 8 | 11 | , | . |
45 | sk_SK | Slovak - Slovakia | 9 | 8 | , | |
46 | sl_SI | Slovenian - Slovenia | 9 | 10 | , | |
47 | sq_AL | Albanian - Albania | 7 | 10 | , | . |
48 | sr_RS | Serbian - Serbia | 9 | 10 | . | |
107 | sv_FI | Swedish - Finland | 9 | 7 | , | |
3 | sv_SE | Swedish - Sweden | 9 | 7 | , | |
49 | ta_IN | Tamil - India | 10 | 8 | . | , |
50 | te_IN | Telugu - India | 10 | 9 | . | , |
51 | th_TH | Thai - Thailand | 10 | 8 | . | , |
52 | tr_TR | Turkish - Turkey | 7 | 9 | , | . |
53 | uk_UA | Ukrainian - Ukraine | 8 | 9 | , | . |
54 | ur_PK | Urdu - Pakistan | 6 | 6 | . | , |
55 | vi_VN | Vietnamese - Vietnam | 16 | 11 | , | . |
56 | zh_CN | Chinese - Peoples Republic of China | 3 | 3 | . | , |
108 | zh_HK | Chinese - Hong Kong SAR | 3 | 3 | . | , |
57 | zh_TW | Chinese - Taiwan | 3 | 2 | . | , |