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 | . | , |