Timeline for MySQL command line formatting with UTF8
Current License: CC BY-SA 4.0
15 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Feb 12, 2022 at 19:34 | history | edited | Dharman♦ | CC BY-SA 4.0 |
edited body
|
| Aug 9, 2020 at 8:12 | history | edited | Nick | CC BY-SA 4.0 |
Typo
|
| May 27, 2020 at 10:13 | history | edited | Martin Taleski | CC BY-SA 4.0 |
fixing mistake
|
| Jan 26, 2019 at 15:30 | history | edited | Martin Taleski | CC BY-SA 4.0 |
expanding answer to cover a wide range of charset problems
|
| Jan 26, 2019 at 15:21 | history | edited | Martin Taleski | CC BY-SA 4.0 |
expanding answer to cover a wide range of charset problems
|
| Dec 24, 2018 at 8:44 | history | edited | Martin Taleski | CC BY-SA 4.0 |
adding a section about utf8mb4 as per comments
|
| Dec 24, 2018 at 6:50 | comment | added | Chindraba |
@reallynice The distinction is a fine one, and valid. If the full 4-byte implementation is needed then the utf8mb4 can be used on the command line; mysql --default-character-set=utf8mb4
|
|
| Jun 20, 2017 at 20:43 | comment | added | Martin Taleski | well it forces them to be utf8, whatever utf8 means in mysql. I have changed it to lowercase so there is no confusion. | |
| Jun 20, 2017 at 20:42 | history | edited | Martin Taleski | CC BY-SA 3.0 |
deleted 1 character in body
|
| Jun 20, 2017 at 8:35 | comment | added | reallynice | I'm not sure that the statement "This [--default-character-set=utf8] forces the character_set_client, character_set_connection and character_set_results variables to be UTF8. " is right, because mysql has also got the utf8mb4 charset, which is their true implementation of UTF8. mysql's utf8 uses only 3 bytes, leaving out a range of characters of the UTF8 table | |
| Sep 9, 2014 at 21:16 | history | edited | Martin Taleski | CC BY-SA 3.0 |
adding more info in the answer, and explanation hot to set it as default
|
| Jul 2, 2014 at 14:24 | history | edited | Martin Taleski | CC BY-SA 3.0 |
added 40 characters in body
|
| Jul 23, 2011 at 12:34 | comment | added | spier |
This did help indeed. So starting mysql command line like this does the trick mysql --default-character-set=utf8
|
|
| Jul 23, 2011 at 12:33 | vote | accept | spier | ||
| Jul 22, 2011 at 9:42 | history | answered | Martin Taleski | CC BY-SA 3.0 |